Previous Page | Next Page

Report Writing

Producing a Frequency Report

A frequency report summarizes data by showing how it falls into different categories. By following the instructions in this section, you can produce a crosstabulation frequency report that shows how many, and what percentage, of each style of house has one, two, three, and four bedrooms.

Style of Houses vs. Number of Bedrooms Frequency Report

[Style of Houses vs. Number of Bedrooms Frequency Report]

Setting Up the Report

  1. To produce a frequency report like the one shown in the previous display, follow this selection path:Tasks [arrow] Report Writing [arrow] CountsThe Select a Style of Report window appears.

    Select a Style of Report Window

    [Select a Style of Report Window]

  2. Select Crosstabulation. The Two-Way Crosstabulation window appears.

    Two-Way Crosstabulation Window

    [Two-Way Crosstabulation 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, column names exist for Row specification or Column specification), then selectFile [arrow] Newto clear these selections.

  6. Select Row specification from the Two-Way Crosstabulation window, and then select the STYLE column. For more information, see Selecting a Column.

  7. Select Column specification, and then select the BEDROOMS column.

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 Style of House vs. Number of Bedrooms Frequency Report as Title 1 to this report.

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.

    Style of House vs. Number of Bedrooms Frequency Report

    [Style of House vs. Number of Bedrooms Frequency Report]

    This report shows the frequency of one, two, three, and four bedroom houses in each style.

  2. If the report is wider or longer than the window, then 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 Two-Way Crosstabulation 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.