|Doing More with SAS/ASSIST Software|
To open the Report Engine window, follow this selection path:
|Tasks||Report Writing||Design Report||Report Engine|
|Tasks||Data Management||Query||Query and Reporting||Report Engine|
Report Engine Window
When you open the Report Engine window, the last report that you created appears. Select New from the File menu to clear the window. You can use New to clear the Report Engine window at any time.
You use commands and make choices from selection lists to produce
reports in the Report Engine window. When you
press TAB, your cursor moves to any field that contains text that you can
edit. The fields in the Report Engine window are
described in the following table. Type a
? in any field and press
ENTER to list possible selections for that field.
||lists the name of the data source. Fill in the Type field before you select the data source.|
||lists the type of data, such as a SAS table or query
or a query on a DB2 table that you saved from the SQL Editor or the Query
window. The default value is
||controls the type of report you want to generate. The
default value is
To produce a report, first select the type of data in the Type field. You can select SAS tables or views (type SAS), a query that was created by using the Query window (type QUERY), or a query that was created by using the SQL Editor window (type SQL). Queries do not contain any data but rather point to one or more tables.
After you select the type of report, type the name of
the data source in the Data field. If you type
? in the Data field and press ENTER, the window that appears depends
on what is in the Type field:
Sin the Cmd field to select a query.
After you select the data source, type of data, and report, the Report Engine window shows you the columns for the data you selected. For example, the following display shows the columns for the AIRLINE.MARCH SAS table. See Creating the AIRLINE Sample Tables for more information on the AIRLINE sample tables.
Report Engine With AIRLINE.MARCH Table
To customize your report, you make modifications as described in the rest of this chapter. To run the report, follow this selection path:
You can use the fields described in the following table to manipulate your report in the Report Engine window.
||indicates the number of the first line of column information shown in the window. If the table has more columns than will fit in the window, the row number is in a different color, and you can type a new number in the Row field to begin the display at the specified row number.|
||indicates the column number of the last column shown in the window.|
||indicates the total number of columns in the data source.|
||enables you to specify commands to manipulate the columns
in the report. Type a
||indicates the order of the columns. (No is an abbreviation for Number). You can change the column
order by typing a new order number over the old order number. To drop a column
from the report, delete (or type blanks over) the number in this field. The
column label and length remain in the window. See the
||sorts the column data in the specified order. Type
||defines what a column represents. Usages change the
appearance of the report. You can type the usage into this field or type a
||indicates the column label. You can change the column
label by typing over the existing label. To reset the label to its original
value, type an
||indicates both the SAS format and data type of a specific
column. You can use any SAS format in this field. The format changes how
the column looks on your report. Type a
Top of Page
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.