Certification Summary---Summary Reports

User:Ywang10/Work

1.Which of the following programs produces this output?

a.proc report data=sasuser.houses nowd; column style condo range split twostory price; define price/ mean ‘average price’; run; b. proc report data=sasuser.houses nowd; column style price; define style /group; define price/ mean ‘average price’; run; c. proc report data=sasuser.houses nowd; column style price; define style /across; define price/ mean ‘average price’run; run; d. proc report data=sasuser.houses nowd; column style price; define style /across ‘condo’ ‘ranch’ ‘split’ ‘twostory’; define price/ mean ‘average price’run; run;

Correct answer:c

In this output, the table cells contain a frequency count for each unique value of an across variable, Style. You don’t have to specify across variable values in your PROC REPORT step.

2.How can you create output with headings that break as shown below?

Style of             Average          Maximum House               Bedrooms           Baths Condo                  2.75              2.5 Ranch                  2.25               3 Split                  2.666666           3

a.You must specify the SPLIT=option in the PROC REPORT statement and use the split character in column headings in DEFINE statements.

b.You must use the default split character in column headings in DEFINE statements.

c.You must specify either the WIDTH=or the SPACING=attribute in DEFINE statements.

d.These headings split this way by default.

Correct answer:d

By default, columns for character variables are the same as the variable’s length, and columns for numeric variables have a width of 9. So these headings split this way by default.