Doing More with the Report Engine |
You can use commands in the Report Engine window Cmd field to modify your report. Type a ? in the Cmd field to list the commands described in the following table.
Command | Name | Description |
---|---|---|
I | Column Information | displays detailed information about a column. See Using the Column Information Window for more information. |
R | Repeat | repeats a column. |
D | Delete | deletes a column from the report only. To restore deleted columns, select Reset Columns from the Edit menu. When you delete a column using D , all information for that column is removed from the Report Engine window. See the No field in Fields in the Report Engine Window for an alternate method of dropping columns from a report. |
T | Subtotal | computes a subtotal on the column for each group defined by a GROUP, PAGE, or BREAK usage. See Usages for more information on usages. |
The following display shows the Report Engine window with the command to repeat the No. of boarded passengers column. This display also shows that the number in the No field for the No. of transfer passengers column has been erased to drop the column from the report. After you press ENTER, repeated fields are indicated with an R between the Cmd and No fields; dropped columns are moved to the bottom of the list, and the other columns are renumbered. Any columns used to create subtotals are indicated with a T.
Using the Cmd Field
Copyright © 2012 by SAS Institute Inc., Cary, NC, USA. All rights reserved.