Question 70 : 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?
1.id style;
2.Get all Questions and Answer from here
3.You need to have paid subscription to access all questions
4.Thanks for considering SAS Certification Material
Correct Answer 3 :
Exp : C and D options are same only diff is that there is style variable in var... But, if the style variable is present in id statement, you don't have to mention it in varstatement, else you will get 2 style variable in the output,
You can access to full explanation to question and answer from this page.