The 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.

Featured in:

RBREAK location </ option(s)>;

Task		Option
Specify the color of the break lines in the REPORT window		COLOR=
Specifies the link text used in the Table of Contents		CONTENTS=
Double overline each value		DOL^*
Double underline each value		DUL^*
Overline each value		OL^*
Start a new page after the last break line of a break located at the beginning of the report		PAGE
Write a blank line for the last break line of a break located at the beginning of the report		SKIP^*
Specify a style element (for the Output Delivery System) for default summary lines, customized summary lines, or both		STYLE=
Include a summary line as one of the break lines		SUMMARIZE
Underline each value		UL^*
* Traditional SAS monospace output only.

Required Arguments

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.

Options

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. [cautionend]

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 TOC. If the CONTENTS= option plus the PAGE and SUMMARIZE options are specified, PROC REPORT uses the value of link-text and places that text in the Table of Contents for the tables created. If the value of CONTENTS= is empty quotation marks, no link is created in the TOC.

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, the default link text in the TOC will show Summary.
Restriction:	For HTML output, the CONTENTS= option has no effect in the HTML body file. It affects only the HTML contents file.
Restriction:	If CONTENTS= is specified, but no PAGE option is specified, 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 TOC.
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 also:	the discussion of FORMCHAR=.
Featured in:	Selecting Variables for a Report

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 also:	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 also:	the discussion of FORMCHAR=.
Featured in:	Calculating Percentages

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 by 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:

If the report item is...		Then its value is...
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 DEFINE statement. 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.)

Featured in:

Selecting Variables for a Report and Calculating Percentages

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 also:	the discussion of FORMCHAR=.

Order of Break Lines

When a default summary contains more than one break line, the order in which the break lines appear is

overlining or double overlining (OL or DOL, traditional SAS monospace output only)
summary line (SUMMARIZE)
underlining or double underlining (UL or DUL, traditional SAS monospace output only)
skipped line (SKIP, traditional SAS monospace output only)
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 COMPUTE Statement and LINE Statement. [cautionend]

Top of Page