Display 18.24 Sample Target Table Data
Note: The target tables in the sample job are temporary output tables that are not
preserved when the SAS session is ended. If you need permanent target tables,
right-click the target tables and click Replace in the pop-up menu.
4. Repeat the process for the other target tables in your forecast.
Frequency of Eye Color By Hair Color
Crosstabulation
Overview
Use the Frequency transformations to produce one-way to n-way frequency and
contingency (crosstabulation) tables. The Frequency transformations are based on the
FREQ procedure, which generates frequency statistics. For more information about this
procedure, see "The FREQ Procedure" section in Base SAS Procedures Guide.
There are two Frequency transformations: Frequency and One-Way Frequency. The
Frequency transformation uses PROC FREQ to compute statistics for complex tests,
measures of association, and stratified analysis of one-way to n-way tables. The One-
Way Frequency transformation is used for simpler PROC FREQ analysis on one-way
tables to examine the relationship between two classification variables. It can also be
used to compute statistics for equal proportions, specified proportions, or the binomial
proportion. The One-Way Frequency transformation also has a subset of the options
available for the Frequency transformation.
Both Frequency transformations control many aspects of the analysis, including the
following:
grouping of rows by the values in one or more columns
how the rows appear in the report
which column or columns are analyzed
You can use the Frequency transformations to generate frequency statistics in a target
and on the Output tab of the Job Editor. ODS output in the form of HTML, PDF, or
Frequency of Eye Color By Hair Color Crosstabulation 385
RTF can be sent to a folder on the SAS Application Server that executes the job. ODS
output can also be sent to any folder with access to that SAS Application Server.
The target receives data only for the source columns that are involved in the analysis.
The target requires two columns that either Frequency transformation populates: Count
receives the total number of occurrences in a category, and Percent receives the
percentages for each category.
You can specify grouping columns in the Frequency transformations. When you do this,
a SAS BY statement orders target rows according to the values in the grouping columns.
The Frequency transformations require that grouping columns be sorted in ascending
order in the source. If you specify grouping columns, you can sort those columns before
the Frequency transformation using a SAS Sort transformation.
For examples of how you can use the Frequency transformations, see the Frequency of
Eye Color By Hair Color Crosstabulation at “Frequency of Eye Color By Hair Color
Crosstabulation” on page 385 and the One-Way Frequency transformation example at
“One-Way Frequency of Eye Color By Region” on page 398.
Problem
You want to generate frequency statistics.
Solution
You can use the Frequency transformation in a SAS Data Integration Studio job to
produce one-way to n-way frequency and contingency (crosstabulation) tables. For
example, you can create a job similar to the sample job featured in this topic. This
sample job generates a list of the numbers of individuals with particular combinations of
hair and eye color by geographical region. The frequency statistics are sent to a target
and to the Output tab in the Job Editor window. The sample job includes the following
tasks:
“Create and Populate the Job” on page 386
“Configure Analytical Options” on page 387
“Configure Reporting Options” on page 393
“Run the Job and View the Output” on page 394
Tasks
Create and Populate the Job
Perform the following steps to create and populate the job:
1. Create an empty SAS Data Integration Studio job.
2. From the Analysis folder in the Transformations tree, select and drag a Frequency
transformation and drop it in the empty job on the Diagram tab in the Job Editor
window.
3. Select and drag the source table from its folder and drop it before the Frequency
transformation on the Diagram tab.
4. Drag the cursor from the source table to the input port of the Frequency
transformation. This action connects the transformation to the source.
386 Chapter 18 Working with Analysis Transformations

Get SAS Data Integration Studio 4.9 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.