Doing More with the Report Engine |
To display information about a column, type I in the Cmd field for the desired column and press ENTER. The following display shows the information for the Departure Date column, as modified in the previous sections.
Column Information Window
When you press TAB in this window, your cursor moves to any field that you can select or that contains text that you can edit to update the information in this window. The information in this window varies according to the type of usage associated with a column.
To reset the Report Header and Report Format to their original values, select Reset from the Edit menu.
The fields on the Column information window are described in the following table.
Field | Description |
---|---|
Column |
indicates the column label stored with the source table. |
Report Header |
indicates the column label to be used in the report. |
Format |
indicates the column format stored with the source table. |
Report format |
indicates the column format to be used in the report. |
Column width |
indicates the width of the column in the report. |
Type |
indicates the type of column data, C for character data, N for numeric data. |
Sort order |
specifies how the column data are sorted in the report. A specifies that the column data is sorted in ascending order in the report. D specifies that the column data is sorted in descending order in the report. |
Column Usage |
indicates the usage for the column. To produce reports other than lists, you must define at least one of the following usages: GROUP, ACROSS, BREAK, or PAGE. See Usages for more information. |
Report Width |
indicates the total width of the report. |
Flow values |
specifies that character columns longer than the width indicated in the Width field are flowed to multiple lines. |
Subtotal |
writes a summary line (a line containing summaries of statistics and computed variables) for each group defined by a BREAK, GROUP, or PAGE usage. This parameter is available only on columns with a BREAK, GROUP, or PAGE usage. |
Display subtotal text |
prints the value of the group to the left of the subtotals. This parameter is available only on columns with a BREAK, GROUP, or PAGE usage for which the Subtotal parameter has been selected. |
The following parameters are available only on columns with BREAK or PAGE usages.
Field | Description |
---|---|
Show as |
Column displays the value of each group in a column to the left of the other columns. Rows displays the value of each group in a line above the data for each group. Selecting Rows activates the other BREAK and PAGE fields. |
Position |
indicates where the group value appears, in spaces from the left margin. |
Display text |
determines whether the group value appears in the report. |
Text |
If Display text is checked, the text you supply in the Text field is used instead of the group value. Leave this field blank to display the group value. |
Insert line |
determines whether to insert blank lines above and below the group value. |
Copyright © 2012 by SAS Institute Inc., Cary, NC, USA. All rights reserved.