REPORT Procedure
- Syntax
- Overview
- Concepts
- Using
- Results
- Examples Selecting Variables for a ReportOrdering the Rows in a ReportUsing Aliases to Obtain Multiple Statistics for the Same VariableConsolidating Multiple Observations into One Row of a ReportCreating a Column for Each Value of a VariableDisplaying Multiple Statistics for One VariableStoring and Reusing a Report DefinitionCondensing a Report into Multiple PanelsWriting a Customized Summary on Each PageCalculating PercentagesHow PROC REPORT Handles Missing ValuesCreating and Processing an Output Data SetStoring Computed Variables as Part of a Data SetUsing a Format to Create GroupsSpecifying Style Elements for ODS Output in the PROC REPORT StatementSpecifying Style Elements for ODS Output in Multiple StatementsUsing Multilabel FormatsUsing the WIDTH= and CELLWIDTH= Style Attributes with PROC REPORT
| Tips: | Supports the Output
Delivery System. For details, see Output Delivery System: Basic Concepts in SAS Output Delivery System: User's Guide. You can use the ATTRIB, FORMAT, LABEL, and WHERE statements with the PROC SORT procedure. For more information, see Statements with the Same Function in Multiple Procedures. You can also use any global statement. For a list, see Global Statements in SAS Statements: Reference. For in-database processing to occur, your data must reside within a supported version of a DBMS that has been properly configured for SAS in-database processing. For more information, see In-Database Processing for PROC REPORT. |
Syntax
PROC REPORT <option(s)>;
COLUMN column-specification(s);
DEFINE report-item / <usage>
<attribute(s)>
<option(s)>
<justification>
<COLOR=color>
<'column-header-1' <…'column-header-n'>>
<style>;
<attribute(s)>
<option(s)>
<justification>
<COLOR=color>
<'column-header-1' <…'column-header-n'>>
<style>;
FREQ variable;
WEIGHT variable;
Table of Procedure Tasks
| Statement | Task | Example |
|---|---|---|
| PROC REPORT Statement | Produce a summary or detail report | Ex. 1, Ex. 2, Ex. 5, Ex. 6, Ex. 7, Ex. 8, Ex. 11, Ex. 12, Ex. 13, Ex. 15, Ex. 16 |
| BREAK Statement | Produce a default summary at a change in the value of a group or order variable | Ex. 2, Ex. 4, Ex. 5, Ex. 8, Ex. 9 |
| BY Statement | Create a separate report for each BY group | |
| CALL DEFINE Statement | Set the value of an attribute for a particular column in the current row | Ex. 4, Ex. 16 |
| COLUMN Statement | Describe the arrangement of all columns and of headings that span more than one column | Ex. 1, Ex. 3, Ex. 5, Ex. 6, Ex. 10, Ex. 11 |
| COMPUTE Statement | Specify one or more programming statements that PROC REPORT executes as it builds the report | Ex. 2, Ex. 3, Ex. 4, Ex. 5, Ex. 9, Ex. 10, Ex. 13, Ex. 16 |
| ENDCOMP Statement | Specify one or more programming statements that PROC REPORT executes as it builds the report | Ex. 2 |
| DEFINE Statement | Describe how to use and display a report item | Ex. 2, Ex. 3, Ex. 4, Ex. 5, Ex. 6, Ex. 9, Ex. 10, Ex. 12, Ex. 13, Ex. 14, Ex. 16 |
| FREQ Statement | Treat observations as if they appear multiple times in the input data set | |
| LINE Statement | Provide a subset of features of the PUT statement for writing customized summaries | Ex. 2, Ex. 3, Ex. 4, Ex. 5, Ex. 9 |
| RBREAK Statement | Produce a default summary at the beginning or end of a report or at the beginning and end of each BY group | Ex. 1, Ex. 10 |
| WEIGHT Statement | Specify weights for analysis variables in the statistical calculations |