A. All Products
B. Sales Report for Last Month All Products C. All Products All Regions
All Figures in Thousands of Dollars D. Sales Report for Last Month All Products All Regions
All Figures in Thousands of Dollars 26
The following SAS program is submitted: data work.new; length word $7; amount = 7;
if amount = 5 then word = 'CAT';
else if amount = 7 then word = 'DOG'; else word = 'NONE!!!'; amount = 5; run;
Which one of the following represents the values of the AMOUNT and WORD variables? A. amount word 5 DOG
B. amount word 5 CAT
C. amount word 7 DOG
D. amount word
7 ' ' (missing character value) 27
The following SAS program is submitted:
proc means data = sasuser.houses std mean max; var sqfeet; run;
Which one of the following is needed to display the standard deviation with only two decimal places?
A. Add the option MAXDEC = 2 to the MEANS procedure statement. B. Add the statement MAXDEC = 7.2; in the MEANS procedure step. C. Add the statement FORMAT STD 7.2; in the MEANS procedure step.
D. Add the option FORMAT = 7.2 option to the MEANS procedure statement. 28
11
Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?
A. non-missing numeric variable values only
B. missing numeric variable values and non-missing numeric variable values only C. non-missing character variables and non-missing numeric variable values only
D. missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variable values 29
The following SAS program is submitted: proc sort data = sasuser.houses out = houses; by style; run;
proc print data = houses; run;
Click on the Exhibit button to view the report produced. style bedrooms baths price CONDO 2 1.5 80050 3 2.5 79350 4 2.5 127150 2 2.0 110700
RANCH 2 1.0 64000 3 3.0 86650 3 1.0 89100 1 1.0 34550
SPLIT 1 1.0 65850 4 3.0 94450 3 1.5 73650
TWOSTORY 4 3.0 107250 2 1.0 55850 2 1.0 69250 4 2.5 102950
Which of the following SAS statement(s) create(s) the report? A. id style; B. id style;
var style bedrooms baths price; C. id style; by style;
var bedrooms baths price; D. id style; by style;
var style bedrooms baths price;
12
30
A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants
to view a list of homes selling for greater than $100,000.
Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations? A. proc print data = sasuser.houses; where price lt 60000; where price gt 100000; run;
B. proc print data = sasuser.houses; where price lt 60000 or price gt 100000; run;
C. proc print data = sasuser.houses;
where price lt 60000 and price gt 100000; run;
D. proc print data = sasuser.houses;
where price lt 60000 or where price gt 100000; run; 31
The value 110700 is stored in a numeric variable.
Which one of the following SAS formats is used to display the value as $110,700.00 in a report? A. comma8.2 B. comma11.2 C. dollar8.2 D. dollar11.2 32
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of \
Which one of the following SAS programs temporarily replaces the label \label \A. proc print data = sasuser.houses; label price = \run;
B. proc print data = sasuser.houses label; label price \run;
C. proc print data = sasuser.houses label; label price = \run;
D. proc print data = sasuser.houses label = \
13
run; 33
The SAS data set BANKS is listed below: BANKS name rate
FirstCapital 0.0718 DirectBank 0.0721 VirtualDirect 0.0728
The following SAS program is submitted: data newbank; do year = 1 to 3; set banks;
capital + 5000; end; run;
Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?
A. 0 observations and 0 variables B. 1 observations and 4 variables C. 3 observations and 3 variables D. 9 observations and 2 variables 34
The following SAS program is submitted: data work.clients; calls = 6;
do while (calls le 6); calls + 1; end; run;
Which one of the following is the value of the variable CALLS in the output data set? A. 4 B. 5 C. 6 D. 7 35
The following SAS program is submitted: data work.pieces; do while (n lt 6); n + 1; end; run;
14
Which one of the following is the value of the variable N in the output data set? A. 4 B. 5 C. 6 D. 7 36
The following SAS program is submitted: data work.sales; do year = 1 to 5; do month = 1 to 12; x + 1; end; end; run;
Which one of the following represents how many observations are written to the WORK.SALES data set? A. 0 B. 1 C. 5 D. 60 37
A raw data record is listed below: --------10-------20-------30 1999/10/25
The following SAS program is submitted: data projectduration; infile 'file-specification'; input date $ 1 - 10; run;
Which one of the following statements completes the program above and computes the duration of the project in days as of today's date?
A. duration = today( ) - put(date,ddmmyy10.); B. duration = today( ) - put(date,yymmdd10.); C. duration = today( ) - input(date,ddmmyy10.); D. duration = today( ) - input(date,yymmdd10.); 38
A raw data record is listed below: --------10-------20-------30 Printing 750
15