The REPORT Procedure

ROPTIONS

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

Path

Tools Options Report

Description

[IMAGE]

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, 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 headers 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 headers without underlining the spaces between them, by using '--' as the last line of each column header instead of using HEADLINE.

HEADSKIP

writes a blank line beneath all column headers (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 header 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 headers, including those that span multiple columns.

Once you suppress the display of column headers in the windowing 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 headers.

BOX

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

surround each page of the report
separate column headers 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, 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, use SAS windowing 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 pagesize 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 linesize
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, 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, 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

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

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 header when it reaches that character and continues the header on the next line. The split character itself is not part of the column header 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 header (rather than entering one from the PROMPTER or DEFINITION window), 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 selecting

View 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, 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 kind 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, 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 linesize, 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.

Chapter Contents
Previous
Next
Top of Page

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