SAS Chapter 8: Creating Enhanced Reports

1. Which attributes or options are reflected in this PROC REPORT output?

SKIPLINE and FORMAT=

CENTER, HEADLINE, HEADSKIP, and either WIDTH=, SPACING=,or FORMAT=

SPACING= only

CENTER, FORMAT=, and HEADLINE

The HEADLINE option underlines the headings, and HEADSKIP option skips a line between the headings and the rows in the report. Also, Style is centered, and the column for PRICE is wider than the default.

Explanation

The HEADLINE option underlines the headings, and HEADSKIP option skips a line between the headings and the rows in the report. Also, Style is centered, and the column for PRICE is wider than the default.

2. When you define an order variable,

The detail rows are ordered according to their formatted values.

You can't create summary reports.

All of the above

Order variables do order rows according to the formatted values of the order variable, and PROC REPORT suppresses repetitious printing of order values. However, you can't use order variables in a summary report.

Explanation

Order variables do order rows according to the formatted values of the order variable, and PROC REPORT suppresses repetitious printing of order values. However, you can't use order variables in a summary report.

3. If you submit this program, where does your PROC REPORT output appear? proc report data=sasuser.houses nowd; column style sqfeet bedrooms price; define style / group; run;

In the PROC REPORT window

As HTML and/or SAS listing output

Both of the above

Neither of the above

In nonwindowing mode, your PROC REPORT output appears as HTML and/or as SAS listing output, depending on your option settings.

Explanation

In nonwindowing mode, your PROC REPORT output appears as HTML and/or as SAS listing output, depending on your option settings.

4. To create a summary report that shows the average number of bedrooms and the maximum number of baths for each style of house, which DEFINE statements do you use in your PROC REPORT step?

Define style / center 'Style of/House';define bedrooms / mean 'Average/Bedrooms';define baths / max 'Maximum/Baths';

Define style / group;define bedrooms / mean 'Average/Bedrooms';define baths / max 'Maximum/Baths';

Define style / order;define bedrooms / mean 'Average/Bedrooms';define baths / max 'Maximum/Baths';

Define style / group;define bedrooms / 'Average/Bedrooms';define baths /'Maximum/Baths';

To create a summary report, you must define a group variable. To produce the statistics that you want, you must specify the MEAN and MAX statistics for Bedrooms and Baths.

Explanation

To create a summary report, you must define a group variable. To produce the statistics that you want, you must specify the MEAN and MAX statistics for Bedrooms and Baths.

5. Suppose you want to create a report using both character and numeric variables. If you don't use any DEFINE statements in your PROC step,

Your PROC REPORT step will not execute successfully.

You can produce only list reports.

You can order rows by specifying options in the PROC REPORT statement.

You can produce only summary reports.

Unless you use DEFINE statements to define order variables or group variables, you can't order rows or produce summary reports. However, DEFINE statements are not required in PROC REPORT steps.

Explanation

Unless you use DEFINE statements to define order variables or group variables, you can't order rows or produce summary reports. However, DEFINE statements are not required in PROC REPORT steps.

6. If Style has four unique values and you submit the following program, which output do you get? (Assume that all other variables are numeric.) proc report data=sasuser.houses nowd; column style sqfeet bedrooms price; define style / group; run;

This program creates a summary report, which consolidates into one row all observations from the data set that have a unique combination of values for the variable Style.

Explanation

This program creates a summary report, which consolidates into one row all observations from the data set that have a unique combination of values for the variable Style.

7. What output does this PROC REPORT step produce? proc report data=sasuser.houses nowd; column style sqfeet bedrooms price; run;

A list report ordered by values of the first variable in the column statement

A summary report ordered by values of the first variable in the COLUMN statement

A list report that calculates the N (frequency) statistic for character variables

By default, PROC REPORT displays character variables as display variables. A report that contains one or more display variables has a detail row for each observation in the data set.

Explanation

By default, PROC REPORT displays character variables as display variables. A report that contains one or more display variables has a detail row for each observation in the data set.

8. Which of the following programs produces this output?

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.

Explanation

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.

9. Which program does not contain an error?

Program c correctly specifies a computed variable in the COLUMN statement, defines the variable in a DEFINE statement, and computes values using the form variable-name.statistic in a compute block.

Explanation

Program c correctly specifies a computed variable in the COLUMN statement, defines the variable in a DEFINE statement, and computes values using the form variable-name.statistic in a compute block.

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

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

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

These headings split this way by default.

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.

Explanation

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.