In SAS, PROC REPORT is a procedure that can be used to generate formatted reports from SAS data sets. The following are some of the common options available in PROC REPORT:
1. DATA: Specifies the input data set for the report.
Syntax:
data=data_set;
2. COLUMN: Specifies the columns to be displayed in the report.
Syntax:
column column1 column2 …;
3. DEFINE: Defines the columns and specifies the summary and format options for each column.
Syntax:
define column_name / options;
Some of the common options that can be used with the DEFINE statement include the following:
• ACROSS: Specifies that the column is an across variable, which is used to create a crosstabulation report. • ORDER: Specifies the order in which the categories of the column are displayed in the report. • FORMAT: Specifies the format to be applied to the values in the column. • COMPUTED: Specifies that the column is a computed column, which is calculated using an expression. • ANALYSIS: Specifies the summary statistic to be calculated for the column. 4. ACROSS: Specifies the across variables, which are used to create a crosstabulation report .
Syntax:
across variable1 variable2 …;
5. SUMMARIZE: Specifies the summary variables, which are used to calculate summary statistics for each group in the report.
Syntax:
summarize variable1 variable2 …;
6. GROUP: Specifies the grouping variables, which are used to group the data for the report.
Syntax:
group variable1 variable2 …;
7. BREAK: Specifies the break variables, which are used to create page breaks in the report.
Syntax:
break variable1 variable2 …;
8. COMPUTE: Defines computed columns, which are calculated using an expression.