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;
run;
Which one of the following contains the footnote text that is displayed in the report?
B. Sales Report for Last Month
All Regions
All Figures in Thousands of Dollars
D. Sales Report for Last Month
All Regions
All Figures in Thousands of Dollars

### 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.

### 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;

### 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;