Chapter Contents

Previous

Next

Producing a Tabular Report

A tabular report displays descriptive statistics in a table format. A tabular report lets you place data into classes or categories for analysis and calculate statistics, such as counts, sums, means, and percentages on these classes. By following the instructions in this section, you can produce a tabular report that shows the mean, minimum, and maximum prices of the houses classified by style.

Setting Up the Report

1. To produce a tabular report like the one shown in the previous display, follow this selection path:

   Tasks

   Report Writing

   Tabular reports

   All tabular reports...

   The Select a Tabular Report window appears.

   Select a Tabular Report Window
   

   

   The Select a Tabular Report window shows the layout for four types of tabular reports: Statistics, Simple Group 1, Simple Group 2, and 2-D Group. To see the Multiple Group and Advanced types, select Additional Reports. To return to the first four types, select Goback at the bottom of the display.

2. Select Simple Group 1 from the Select a Tabular Report window. The Simple group 1 window appears.

   Simple Group 1 Window
   

   

3. If the active table is SASUSER.HOUSES, continue to the next step. Otherwise, select Table, and then select the SASUSER.HOUSES table. For more information on selecting tables, see Selecting a Table.

4. If there is an active Subset Data selection (indicated with BY, WHERE, or ROWS next to the Subset data button), clear the selection. For more information, see Clearing a Subset Data Selection.

5. If other report selections exist (for example, a column name is listed under Class), follow this selection path to clear these selections:

   File

   New

6. Select Column from the Simple group 1 window, and then select the PRICE column. For more information, see Selecting a Column.

7. Select Statistics from the Second Report Style window. A list of statistics that you can choose for the report appears.

   Select Statistics Window
   

   

   The number of statistics that you can select is listed at the top of the statistics list. Each time you select a statistic, an asterisk appears next to the statistic to indicate that the statistic has been selected. As each statistic is selected, it moves to the top of the list. The order of the chosen statistics in the list is the order of the statistics on the report.

   To de-select a statistic, select it again; the asterisk disappears.

8. Select the MEAN, MIN, and MAX statistics from the Select Statistics window. Select OK. The Simple Group 1 window reappears.

9. Select Class from the Simple group 1 window, and then select the STYLE column as your classification column. A classification column is a column you want to use to classify the data into groups or categories of information.

Adding Titles

You can customize the report by adding titles and footnotes, changing the page dimensions, and selecting headings. Refer to Adding Titles for instructions on adding titles to the report. Add the title Mean, Min, and Max Price of Houses by Style as Title 1 to this report.

Because the same set of titles and footnotes is used for all SAS/ASSIST tasks, the titles and footnotes most recently used in your SAS/ASSIST session are used unless you change or reset them in the Titles and Footnotes windows.

Running the Report

After you have finished setting up the report, run the report.

1. Follow this selection path:

   Run

   Submit

   The report appears in the Output window.

   Tabular Report of Houses by Style
   

   

   This report shows the mean, minimum, and maximum price for the different styles of houses in the HOUSES table.

2. If the report is wider or longer than one display, use the scroll bars or the FORWARD, BACKWARD, LEFT, and RIGHT function keys to look at the report.

Printing the Report

If you do not want to print the report, go to the next section. To print the report, follow the directions in Printing the Report.

Exiting This Task

When you have finished viewing or printing your report, return to the Simple group 1 window by using one of the following methods, depending on your operating environment:

• Use the PREVWIND function key.

• Click on the SAS/ASSIST window.

To return to the WorkPlace menu or move on to another task, follow the directions in Exiting a Task.

Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.