Doing More with the Report Engine

Modifying a Report's Column Order, Headers, and Formats

You can use fields in the Report Engine window to modify the report's column order, headers, and formats as follows:

Rearrange the report's columns by changing the numbers of the No (Number) field.
change the column headers by typing a new column header over the existing one.
Change the presentation of the column in your report by selecting a new format in the Length field.

After you make your changes and press ENTER, the columns are reordered in the Report Engine window and are renumbered to account for any dropped columns. Also, the new formats are listed in the Length field.

Note: If the table has been sorted, you can set the User Profile option Column Order to automatically put the BY column or columns at the top of the list in the Report Engine window. See Customizing SAS/ASSIST Software for information. [cautionend]

The following display shows the Report Engine window with the AIRLINE.MARCH data file with the following modifications:

The Weight of mail (kg), Weight of freight (kg), No. of transfer passengers, and No. of disembarked pass. columns have been dropped from the report by erasing their position numbers in the No field.
The order of the Departure date and Flight number columns has been reversed.
The column header for the No. of non-revenue pass. column has been changed to No. of non-paying passengers..
The format for the Departure date column has been changed to WEEKDATE17. using the Column Information window (see Using the Column Information Window for details).
The Departure Date column has been sorted in ascending order.
The width for all columns has been changed to 10, except for the width for Flight number, which has been changed to 6, and the Departure Date column, which has been changed to 17 to accommodate its new format. Column widths do not appear in the Report Engine window; you view and change the column width in the Column Information window. See Using the Column Information Window for more information.
The title "Passenger Information for March" has been added by selecting Titles from the Edit menu, and centered by selecting Page Layout from the Edit menu. Title information does not appear on the Report Engine window.
The repeated No. of boarded passengers column has been assigned a usage of MAX, the column header has been changed to Max. No. of boarded passengers, and the width has been changed to 10. For information on changing usages, see Modifying a Report with Usages.
The Departure date column has been assigned a usage of BREAK so that the report breaks on each new date value.

Report Engine Window with Modifications to AIRLINE.MARCH Table

[Report Engine Window with Modifications to AIRLINE.MARCH Table]

The following display shows the modified list report for the passenger data in the AIRLINE.MARCH table. The report has been scrolled forward to show that the maximum number of boarded passengers for a single flight for each day is given at the bottom of the data for each day.

AIRLINE.MARCH Listing Report With Modifications

[AIRLINE.MARCH Listing Report With Modifications]

Top of Page