REPORT Procedure

RBREAK Statement

Produces a default summary at the beginning or end of a report or at the beginning or end of each BY group.
Selecting Variables for a Report

Calculating Percentages

Syntax

RBREAK location </ option(s)>;

Summary of Optional Arguments

specifies the color of the break lines in the REPORT window.
specifies the link text used in the table of contents.
double overlines each value.
double underlines each value.
overlines each value.
starts a new page after the last break line of a break located at the beginning of the report.
writes a blank line for the last break line of a break located at the beginning of the report.
specifies a style element (for the Output Delivery System) for default summary lines, customized summary lines, or both.
includes a summary line as one of the break lines.
underlines each value.

Required Argument

location
controls the placement of the break lines and is either of the following:
AFTER
places the break lines at the end of the report.
BEFORE
places the break lines at the beginning of the report.

Optional Arguments

COLOR=color
specifies the color of the break lines in the REPORT window. You can use the following colors:
BLACK
MAGENTA
BLUE
ORANGE
BROWN
PINK
CYAN
RED
GRAY
WHITE
GREEN
YELLOW
Default:The color of Foreground in the SASCOLOR window. (For more information, see the online Help for the SASCOLOR window.)
Restriction:This option affects output in the interactive report window environment only.
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.
CONTENTS='link-text'
specifies the text for the entries in the HTML contents file or PDF table of contents for the output that is produced by PROC REPORT. Only the RBREAK BEFORE statement with the PAGE and SUMMARIZE options specified creates a table within the table of contents. If the CONTENTS= option plus the PAGE and SUMMARIZE options are specified, then PROC REPORT uses the value of link-text and places that text in the table of contents for the tables that are created. If the value of CONTENTS= is empty quotation marks, then no link is created in the table of contents.
For information about HTML and PDF output, see Output Delivery System.
Default:If an RBREAK BEFORE statement is present and the PAGE and SUMMARIZE options are specified, but no CONTENTS= option is specified, then the default link text in the table of contents will show Summary.
Restrictions:For HTML output, the CONTENTS= option has no effect in the HTML body file. It affects only the HTML contents file.

If CONTENTS= is specified, but no PAGE option is specified, then PROC REPORT generates a warning message in the SAS log file. Only RBREAK BEFORE / with the SUMMARIZE and PAGE options specified can actually create a table in the table of contents.

Interaction:For RTF output, the CONTENTS= option has no effect on the RTF body file unless you turn on the CONTENTS=YES option in the ODS RTF statement. In that case, a Table of Contents page is inserted at the front of your RTF output file. Your CONTENTS= option text from PROC REPORT will then show up in this separate Table of Contents page.
Tip:HTML output can now have additional anchor tags.
DOL
(for double overlining) 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 (=)
Restriction:This option has no effect on ODS destinations other than traditional SAS monospace output.
Interaction:If you specify both the OL and DOL options, then PROC REPORT honors only OL.
See:The discussion of FORMCHAR= .
DUL
(for double underlining) 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 (=)
Restriction:This option has no effect on ODS destinations other than traditional SAS monospace output.
Interaction:If you specify both the UL and DUL options, then PROC REPORT honors only UL.
See:The discussion of FORMCHAR= .
OL
(for overlining) 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 (-)
Restriction:This option has no effect on ODS destinations other than traditional SAS monospace output.
Interaction:If you specify both the OL and DOL options, then PROC REPORT honors only OL.
See:the discussion of FORMCHAR=.
PAGE
starts a new page after the last break line of a break located at the beginning of the report. On RBREAK BEFORE, the PAGE option starts a new table.
Restriction:This option has no affect on the OUTPUT destination.
SKIP
writes a blank line after the last break line of a break located at the beginning of the report.
Restriction:This option has no effect on ODS destinations other than traditional SAS monospace output.
STYLE<(location(s))>=<style-element-name><[style-attribute-specification(s)]>
specifies the style element to use for default summary lines that are created with the RBREAK statement. See Using Style Elements in PROC REPORT for details.
Restriction:This option affects only the HTML, RTF, and Printer destinations.
Tip:FONT names that contain characters other than letters or underscores must be enclosed in quotation marks.
SUMMARIZE
includes a summary line as one of the break lines. A summary line at the beginning or end of a report contains values for
  • statistics
  • analysis variables
  • computed variables
The following table shows how PROC REPORT calculates the value for each type of report item in a summary line created by the RBREAK statement:
Report Item
Resulting Value
Statistic
Value of the statistic over all observations in the set
Analysis variable
Value of the statistic specified as the usage option in the DEFINE statement. PROC REPORT calculates the value of the statistic over all observations in the set. The default usage is SUM.
Computed variable
Results of the calculations based on the code in the corresponding compute block. (See COMPUTE Statement.)
UL
(for underlining) 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 (-)
Restriction:This option has no effect on ODS destinations other than traditional SAS monospace output.
Interaction:If you specify both the UL and DUL options, then PROC REPORT honors only UL.
See:The discussion of FORMCHAR= .

Details

Order of Break Lines

When a default summary contains more than one break line, the order in which the break lines appear is
  1. overlining or double overlining (OL or DOL, traditional SAS monospace output only)
  2. summary line (SUMMARIZE)
  3. underlining or double underlining (UL or DUL, traditional SAS monospace output only)
  4. skipped line (SKIP, traditional SAS monospace output only)
  5. page break (PAGE)
Note: If you define a customized summary for the break, then customized break lines appear after underlining or double underlining. For more information about customized break lines, see the COMPUTE statement and the LINE statement LINE Statement.