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.
You want to generate frequency statistics.
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
• “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
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
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