The REPORT Procedure

ROPTIONS

Displays choices that control the layout and display of the entire report and identifies the SAS library and catalog containing CBT or HELP entries for items in the report.

Path

Tools Options Report

Description

[ROPTIONS Window]

Modes

DEFER

stores the information for changes and makes the changes all at once when you turn DEFER mode off or select View Refresh

DEFER is particularly useful when you know that you need to make several changes to the report but do not want to see the intermediate reports.

By default, PROC REPORT redisplays the report in the REPORT window each time you redefine the report by adding or deleting an item, by changing information in the DEFINITION window, or by changing information in the BREAK window.

PROMPT

opens the PROMPTER window the next time that you add an item to the report.

Options

CENTER

centers the report and summary text (customized break lines). If CENTER is not selected, then the report is left-justified.

PROC REPORT honors the first of these centering specifications that it finds:

the CENTER or NOCENTER option in the PROC REPORT statement or the CENTER toggle in the ROPTIONS window
the CENTER or NOCENTER option stored in the report definition loaded with REPORT= in the PROC REPORT statement
the SAS system option CENTER or NOCENTER.

When PROC REPORT's CENTER option is in effect, PROC REPORT ignores spacing that precedes the leftmost variable in the report.

HEADLINE

underlines all column headings and the spaces between them at the top of each page of the report.

HEADLINE underlines with the second formatting character. (See the discussion of FORMCHAR=.)

Default:	hyphen (-)
Tip:	In traditional (monospace) SAS output, you can underline column headings without underlining the spaces between them, by using '--' as the last line of each column heading instead of using HEADLINE.

HEADSKIP

writes a blank line beneath all column headings (or beneath the underlining that the HEADLINE option writes) at the top of each page of the report.

NAMED

writes name= in front of each value in the report, where name is the column heading for the value.

Tip:	Use NAMED in conjunction with WRAP to produce a report that wraps all columns for a single row of the report onto consecutive lines rather than placing columns of a wide report on separate pages.
Interaction:	When you use NAMED, PROC REPORT automatically uses NOHEADER.

NOHEADER

suppresses column headings, including headings that span multiple columns.

Once you suppress the display of column headings in the interactive report window environment, you cannot select any report items.

SHOWALL

overrides the parts of a definition that suppress the display of a column (NOPRINT and NOZERO). You define a report item with a DEFINE statement or in the DEFINITION window.

WRAP

displays one value from each column of the report, on consecutive lines if necessary, before displaying another value from the first column. By default, PROC REPORT displays values for only as many columns as it can fit on one page. It fills a page with values for these columns before starting to display values for the remaining columns on the next page.

Interaction:	When WRAP is in effect, PROC REPORT ignores PAGE in any item definitions.
Tip:	Typically, you use WRAP in conjunction with NAMED to avoid wrapping column headings.

BOX

uses formatting characters to add line-drawing characters to the report. These characters

surround each page of the report
separate column headings from the body of the report
separate rows and columns from each other.

Interaction:	You cannot use BOX if you use WRAP in the PROC REPORT statement or ROPTIONS window or if you use FLOW in any item's definition.
See also:	For information about formatting characters, see the discussion of FORMCHAR=.

MISSING

considers missing values as valid values for group, order, or across variables. Special missing values that are used to represent numeric values (the letters A through Z and the underscore (_) character) are each considered as a different value. A group for each missing value appears in the report. If you omit the MISSING option, then PROC REPORT does not include observations with a missing value for one or more group, order, or across variables in the report.

Attributes

LINESIZE=

specifies the line size for a report. PROC REPORT honors the first of these line-size specifications that it finds:

LS= in the PROC REPORT statement or LINESIZE= in the ROPTIONS window
the LS= setting stored in the report definition loaded with REPORT= in the PROC REPORT statement
the SAS system option LINESIZE=.

Range:	64-256 (integer)
Tip:	If the line size is greater than the width of the REPORT window, then use SAS interactive report window environment commands RIGHT and LEFT to display portions of the report that are not currently in the display.

PAGESIZE=

specifies the page size for a report. PROC REPORT honors the first of these page size specifications that it finds:

PS= in the PROC REPORT statement or PAGESIZE= in the ROPTIONS window
the PS= setting stored in the report definition loaded with REPORT= in the PROC REPORT statement
the SAS system option PAGESIZE=.

Range:

15-32,767 (integer)

COLWIDTH=

specifies the default number of characters for columns containing computed variables or numeric data set variables.

Range:	1 to the line size
Default:	9
Interaction:	When setting the width for a column, PROC REPORT first looks at WIDTH= in the definition for that column. If WIDTH= is not present, then PROC REPORT uses a column width large enough to accommodate the format for the item. (For information about formats, see the discussion of Format=.) If no format is associated with the item, then the column width depends on variable type:

If the variable is a...		Then the column width is the...
character variable in the input data set		length of the variable
numeric variable in the input data set		value of the COLWIDTH= option
computed variable (numeric or character)		value of the COLWIDTH= option

SPACING=space-between-columns

specifies the number of blank characters between columns. For each column, the sum of its width and the blank characters between it and the column to its left cannot exceed the line size.

Default:	2
Interaction:	PROC REPORT separates all columns in the report by the number of blank characters specified by SPACING= in the PROC REPORT statement or the ROPTIONS window unless you use SPACING= in the definition of a particular item to change the spacing to the left of that item.
Interaction:	When CENTER is in effect, PROC REPORT ignores spacing that precedes the leftmost variable in the report.

SPLIT='character'

specifies the split character. PROC REPORT breaks a column heading when it reaches that character and continues the heading on the next line. The split character itself is not part of the column heading although each occurrence of the split character counts toward the 40-character maximum for a label.

Default:	slash (/)
Interaction:	The FLOW option in the DEFINE statement honors the split character.
Note:	If you are typing over a heading (rather than entering one from the PROMPTER or DEFINITION window), then you do not see the effect of the split character until you refresh the screen by adding or deleting an item, by changing the contents of a DEFINITION or a BREAK window, or by selectingView Refresh

PANELS=number-of-panels

specifies the number of panels on each page of the report. If the width of a report is less than half of the line size, then you can display the data in multiple sets of columns so that rows that would otherwise appear on multiple pages appear on the same page. Each set of columns is a panel. A familiar example of this type of report is a telephone book, which contains multiple panels of names and telephone numbers on a single page.

When PROC REPORT writes a multipanel report, it fills one panel before beginning the next.

The number of panels that fits on a page depends on the

width of the panel
space between panels
line size.

Default:	1
Tip:	If number-of-panels is larger than the number of panels that can fit on the page, then PROC REPORT creates as many panels as it can. Let PROC REPORT put your data in the maximum number of panels that can fit on the page by specifying a large number of panels (for example, 99).
See also:	For information about specifying the space between panels see the discussion of PSPACE=. For information about setting the line size, see the discussion of LINESIZE=).

PSPACE=space-between-panels

specifies the number of blank characters between panels. PROC REPORT separates all panels in the report by the same number of blank characters. For each panel, the sum of its width and the number of blank characters separating it from the panel to its left cannot exceed the line size.

Default:

User Help

identifies the library and catalog containing user-defined help for the report. This help can be in CBT or HELP catalog entries. You can write a CBT or HELP entry for each item in the report with the BUILD procedure in SAS/AF software. You must store all such entries for a report in the same catalog.

Specify the entry name for help for a particular report item in the DEFINITION window for that report item or in a DEFINE statement.

Top of Page