The REPORT Procedure |
Path |
Edit Summarize information
After you select Summarize Information, PROC REPORT offers you four choices for the location of the break:
Before Item
After Item
At the top
At the bottom.
After you select a location, the BREAK window opens.
Note: To create a break before or after detail lines (when the value of a group or order variable changes), you must select a variable before you open the BREAK window.
Description |
Note: For information about changing the formatting characters that are used by the line drawing options in this window, see the discussion of FORMCHAR=.
Options |
uses the second formatting character to overline each value
that appears in the summary line
that would appear in the summary line if you specified the SUMMARIZE option.
Default: | hyphen (-) |
Interaction: | If you specify options to overline and to double overline, then PROC REPORT overlines. |
uses the 13th formatting character to overline each value
that appears in the summary line
that would appear in the summary line if you specified the SUMMARIZE option.
Default: | equal sign (=) |
Interaction: | If you specify options to overline and to double overline, then PROC REPORT overlines. |
uses the second formatting character to underline each value
that appears in the summary line
that would appear in the summary line if you specified the SUMMARIZE option.
Default: | hyphen (-) |
Interaction: | If you specify options to underline and to double underline, then PROC REPORT underlines. |
uses the 13th formatting character to underline each value
that appears in the summary line
that would appear in the summary line if you specified the SUMMARIZE option.
Default: | equal sign (=) |
Interaction: | If you specify options to underline and to double underline, then PROC REPORT underlines. |
writes a blank line for the last break line.
This option has no effect if you use it in a break at the end of a report.
starts a new page after the last break line. This option has no effect in a break at the end of a report.
Interaction: | If you use this option in a break on a variable and you create a break at the end of the report, then the summary for the whole report is on a separate page. |
writes a summary line in each group of break lines. A summary line contains values for
statistics
analysis variables
computed variables.
A summary line between sets of observations also contains
the break variable (which you can suppress with Suppress break value)
other group or order variables to the left of the break variable.
The following table shows how PROC REPORT calculates the value for each type of report item in a summary line created by the BREAK window:
If the report item is... | Then its value is... | |
---|---|---|
the break variable | the current value of the variable (or a missing value if you select suppress break value ) | |
a group or order variable to the left of the break variable | the current value of the variable | |
a group or order variable to the right of the break variable, or a display variable anywhere in the report | missing* | |
a statistic | the value of the statistic over all observations in the set | |
an analysis variable | the value of the statistic specified as the usage option in the item's definition. PROC REPORT calculates the value of the statistic over all observations in the set. The default usage is SUM. | |
a computed variable | the results of the calculations based on the code in the corresponding compute block. (See COMPUTE Statement.) | |
*If you reference a variable with a missing value in a customized summary line, then PROC REPORT displays that variable as a blank (for character variables) or a period (for numeric variables). |
suppresses printing of
the value of the break variable in the summary line
any underlining and overlining in the break lines in the column containing the break variable.
If you select Suppress break value, then the value of the break variable is unavailable for use in customized break lines unless you assign it a value in the compute block that is associated with the break.
Color |
From the list of colors, select the one to use in the REPORT window for the column heading and the values of the item that you are defining.
Default: | The color of Foreground in the SASCOLOR window. (For more information, see the online Help for the SASCOLOR window.) |
Note: | Not all operating environments and devices support all colors, and in some operating environments and devices, one color might map to another color. For example, if the DEFINITION window displays the word BROWN in yellow characters, then selecting BROWN results in a yellow item. |
Buttons |
opens the COMPUTE window and enables you to associate a compute block with a location in the report.
applies the information in the BREAK window to the report and closes the window.
closes the BREAK window without applying information to the report.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.