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.

Details

Path

Toolsthen selectOptionsthen selectReport

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 Viewthen selectRefresh.
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 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 <(position(s))>='formatting-character(s)' .)
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.
Interaction:When you use NAMED, PROC REPORT automatically uses NOHEADER.
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.
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:For information about formatting characters, see the discussion of FORMCHAR <(position(s))>='formatting-character(s)' .
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.
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:
Variable
Resulting Column Width
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
Default:9
Range:1 to the line size
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
Interactions: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.

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.
Tip: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 DEFINITIONor a BREAKwindow, or by selectingViewthen selectRefresh.
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: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:4
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.
Copyright © SAS Institute Inc. All rights reserved.