|Getting Started with the SAS System Using SAS/ASSIST Software|
Dynamic reports enable you to set up a report and then drill down to view more details of the report.
|Creating the AIRLINE Sample Tables|
To appreciate the power of the dynamic report, you should use large and complex tables. This section shows you how to create the AIRLINE sample tables, a set of tables for a fictitious airline company called International Airways. The AIRLINE sample tables are more complex than the SAS/ASSIST sample tables. There are tables with employee information as well as tables with information about flights, delays, boarding numbers, and so on. To create the AIRLINE tables, follow these steps:
sampltabin these examples. See the SAS companion for your operating environment, or contact the SAS Software Consultant at your site if you do not know how to perform this step.
Note: The name
sampltab that we use in these examples is the physical file or directory name. Do not confuse this name with the libname, which you will specify in a later
SAMPLSAS Source Code
* libname &library "&sysjobid..sas.assist.sampltab";You may need to scroll further down to find this line. This line is the LIBNAME statement that SAS software uses to assign a libref to a physical file or directory. For more information on librefs, see SAS Data Libraries.
|OS/2 or Windows||
AIRLINE Sample Table Statistics
Note: The Airline
libref is assigned for the duration of your current SAS session only. The next time you invoke the SAS System and SAS/ASSIST software, you will need to assign the libref again by following the
directions in Using SAS/ASSIST Software to Assign a New Libref. Alternatively, you can specify that the Airline libref be automatically defined, each time you invoke the SAS
System, by assigning the libref in the SAS Explorer window. See the online help for
the SAS Explorer window for details.
|Creating the Report|
To create a dynamic report, you must add usages to the Usage column. Usages determine what a column represents and change the appearance of a report. For dynamic reports, usages determine the columns on which you can drill down.
AIRLINE.MARCHand then press ENTER in the Report Engine window's Data field.
|Column No.||Usage||Column Header|
The usages for the columns create a drill-down report that shows the sum of the mail, freight, number of passengers boarded, number of passengers transferred, number of nonpaying passengers, and the number of disembarked passengers. Each of the columns can be shown by flight number, departure time, capacity, and date. The column headers have been shortened so that they fit in the Dynamic Report window buttons.
DRILLin the Report field, and then press ENTER.
Dynamic Report Window
Information by Flight Number
The figures for nonpaying passengers and deplaned passengers do not initially appear. If the report has more columns than can be displayed in the window, the scroll buttons (the small buttons below the eight analysis buttons) contain arrows to indicate the availability of additional columns. Select the right-arrow button to see columns to the right. Each time you select a scroll button, one new column appears.
Information by Date for Flight 202
Capacity Information for Flight 202 on March 5, 1994
|Exiting This Task|
When you are ready to return to the WorkPlace menu or move on to another task, follow the directions in Exiting a Task.
Top of Page
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.