|Doing More with SAS/ASSIST Software
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
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
The following display shows the Report
Engine window with the AIRLINE.MARCH data file with the following
- 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
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
using the Column Information window (see Using the Column Information Window for details).
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
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
The following display shows the modified list
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
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.