Doing More with SAS/ASSIST Software

Using the Column Information Window

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

[IMAGE]

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.

Fields in the Column Information Window
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.

***Fields in the Column Information Window***
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.

Additional Fields in the Column Information Window for 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.

***Additional Fields in the Column Information Window for 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.

Chapter Contents
Previous
Next
Top of Page