Previous Page | Next Page

Doing More with Data Analysis

Generating a One-way Frequency Table

You can use the Elementary item on the Data Analysis menu to generate frequency tables. Frequency tables show the distribution of column values and can include frequencies, cumulative frequencies, percentages of the total frequency, and cumulative percentages for each level, or distinct value, of the analysis column. In this section you create a one-way frequency table showing the frequency of use of a seat belt in the automotive accidents recorded in the HIGHWAY table.

The one-way frequency table task can generate tables for both numeric and character columns. However, if you have a numeric column with many distinct values, the resulting table may not be informative.

Note:    SAS/STAT software is not required to complete this task.  [cautionend]


Additional Information

For additional information on creating frequency tables, refer to "The FREQ Procedure" in the Base SAS Procedures Guide.


Instructions

  1. Follow this selection path:Tasks [arrow] Data analysis  [arrow] Elementary  [arrow] Frequency Tables  [arrow] Generate One-Way Frequency TableThe One-Way Frequency Table window appears.

    One-way Frequency Table Window

    [One-way Frequency Table Window]

  2. Use the Table button to select the SASUSER.HIGHWAY table.

  3. Use the Analysis columns button to select SEATBELT as the analysis column.

  4. Follow this selection path:Run [arrow] Submit

    Note:   You can select as many analysis columns as you want, up to the number of numeric columns in the table. A frequency table is generated for each analysis column. Any columns selected as BY or weight columns are not displayed in the Select Table Variables window.  [cautionend]

    The frequency table appears showing how often a seat belt was worn in the automotive accidents recorded in the HIGHWAY table.

    One-way Frequency Table Output

    [One-way Frequency Table Output]

  5. Return to SAS/ASSIST software from the Output window. See Returning to SAS/ASSIST Windows from the Output Window for more information.

Previous Page | Next Page | Top of Page