ROWS Statement
- ROWS row-list / options;
ROWS statements define the rows
of the report. The ROWS statement can be abbreviated ROW.
The specified row names must be valid SAS names.
Abbreviated lists, as described in SAS Language: Reference,
can also be used.
You can use as many ROWS statements as you need.
A ROWS statement can describe more than one row,
and one row of the report can be described with several
different ROWS statements. The order of the rows in the report
is determined by the order of appearance of row names in ROWS
statements. The first occurrence of the name
determines where the row is located.
The following options can be used in the ROWS statement:
Option for Row Type
- CHAR
-
indicates that the rows contain character data.
Options for Row Titling
You can specify as many lines of row titles as needed.
If no options are specified, the names from the ROWS statement are used
as row titles.
Any or all of the following options can be used in a row title:
- _LABEL_
-
uses labels as row titles for the row or rows listed in the ROWS statement.
If a label is not provided, the name of the row is substituted.
Refer to SAS Language: Reference
for more information on the LABEL statement.
- _NAME_
-
uses row names in row titles for the row or rows listed in the ROWS statement.
- "row title"
-
specifies that the string of characters enclosed in quotes
is to be used in the row title for the row or rows listed in
the ROWS statement. Each quoted string appears on a separate
line of the heading.
Options for Row Print Control
- +n
-
indents n spaces from the margin for the rows in the ROWS statement.
- DOL
-
overlines the rows listed in the ROWS statement with double lines.
Overlines are printed on the line before any row
titles or data for the row.
- DUL
-
underlines the rows listed in the ROWS statement with double lines.
Underlines are printed on the line after the data for the row.
A row can have both an underline and an overline option.
- NOPRINT
-
suppresses printing of the rows listed in the ROWS statement.
This option enables you to create
rows to be used for intermediate calculations without
having those rows printed.
- NOZERO
-
suppresses the printing of a row when all the values are 0 or missing.
- OL
-
overlines the rows listed in the ROWS statement with a single line.
Overlines are printed on the line before any row
titles or data for the row.
- OVERPRINT
-
overprints titles, values, overlining, and underlining associated
with rows listed in the ROWS statement. The OVERPRINT option can be
abbreviated OVP.
This option is valid only when the system option OVP is in effect.
Refer to SAS Language: Reference for more information about
the OVP option.
- _PAGE_
-
starts a new page of the report before printing these rows.
- SKIP
-
prints a blank line after the data lines for these rows.
- UL
-
underlines the rows listed in the ROWS statement with a single line.
Underlines are printed on the line after the data for the row.
A row can have both an underline and an overline option.
Options for Row Formatting
Row formatting options take precedence over column-formatting options
when the input data set is transposed.
Row print width can never be wider than column width. Character values are
truncated on the right.
- FORMAT= format
-
specifies a format for printing the values of the rows
listed in the ROWS statement. The FORMAT= option can be abbreviated as
F=.
- LJC
-
left-justifies character rows in each column.
- ZERO= "text"
-
substitutes text when the value in the row is 0 or missing.
Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.