EZ Study

Actuarial Biology Chemistry Economics Calculators Confucius Engineer
Physics
C.S.

SAS Programing Certification Exam
Practice Questions & Answer set-24

### Practice Question 119

The following SAS program is submitted:
footnote1 'Sales Report for Last Month';
footnote2 'Selected Products Only';
footnote3 'All Regions';
footnote4 'All Figures in Thousands of Dollars';
proc print data = sasuser.shoes;
footnote2 'All Products';
run;
Which one of the following contains the footnote text that is displayed in the report?
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

Answer is C.

### Practice Question 120

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.

Answer is B.

### Practice Question 121

The following SAS program is submitted:
proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;

run; here is 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;

Answer is C

### Practice Question 122

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;
Click to Get Those Highly Recommended SAS Programmers' Books
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;

Answer is B

Related links:

Continue to SAS Practice Exam Question Answer Set-25   SAS interview Questions Answers
Back to SAS Practice Exam Question Answer Set-23   SAS Tutorial   Statistics Tutorial