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.
-
CHAR
-
indicates that the rows contain character data.
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. See SAS Language: Reference for more information about 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. See 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.