Previous Page | Next Page

Report Writing

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.

[Tabular report output]

Setting Up the Report

  1. To produce a tabular report like the one shown in the previous display, follow this selection path:Tasks [arrow] Report Writing [arrow] Tabular reports [arrow] All tabular reportsThe Select a Tabular Report window appears.

    Select a Tabular Report Window

    [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

    [Simple Group 1 Window]

  3. If the active table is SASUSER.HOUSES, then 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 Subset data), then 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), then selectFile [arrow] Newto clear these selections.

  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

    [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 in which the statistics appear 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 [arrow] SubmitThe report appears in the Output window.

    Tabular Report of Houses by Style

    [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, then 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:

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

Previous Page | Next Page | Top of Page

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