Creates
a separate report on a separate page for each BY group.
Restriction: |
If you use the BY statement, then you must
use the NOWINDOWS option in the PROC
REPORT statement.
|
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.
|
Main discussion: |
BY
|
BY <DESCENDING> variable-1
<...<DESCENDING> variable-n>
<NOTSORTED>;
|
- 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.
- 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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.