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
BY Statement
Creates a separate report on a separate page for
each BY group.
| Restriction: | If you use the BY statement, then you must use the |
| Interaction: | If you use the RBREAK statement in a report that uses BY processing, then PROC REPORT creates a default summary for each BY group. In this case, you cannot summarize information for the whole report. |
| Tip: | Using the BY statement does not make the FIRST. and LAST. variables available in compute blocks. |
| See: | BY |
Syntax
Required Argument
- variable
-
specifies the variable that the procedure uses to form BY groups. You can specify more than one variable. If you do not use the NOTSORTED option in the BY statement, then the observations in the data set either must be sorted by all the variables that you specify or must be indexed appropriately. Variables in a BY statement are called BY variables.
Optional Arguments
- DESCENDING
-
specifies that the data set is sorted in descending order by the variable that immediately follows the word DESCENDING in the BY statement.
- NOTSORTED
-
specifies that observations are not necessarily sorted in alphabetic or numeric order. For example, the data are grouped in chronological order.The requirement for ordering or indexing observations according to the values of BY variables is suspended for BY-group processing when you use the
NOTSORTED option. In fact, the procedure does not use an index if you specify NOTSORTED. The procedure defines a BY group as a set of contiguous observations that have the same values for all BY variables. If observations with the same values for the BY variables are not contiguous, then the procedure treats each contiguous set as a separate BY group.