ROWS Statement |
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.
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:
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.
uses row names in row titles for the row or rows listed in the ROWS statement.
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.
indents n spaces from the margin for the rows in the ROWS statement.
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.
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.
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.
suppresses the printing of a row when all the values are 0 or missing.
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.
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.
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.
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.