Databases Reference
In-Depth Information
Example: Using a Generated Transformation in a Job
Preparation
Suppose that you need to perform a special task with a data set, and none of the
standard transformations in the SAS Data Integration Studio Process Library support
this task. An administrator can use the Transformation Generator wizard to create a
custom transformation and make it available in the Process Library. The generated
transformation can then be used in any SAS Data Integration Studio job.
For example, suppose that you needed to create a report that displays hitting
statistics for baseball teams. The following display shows the kind of output that is
desired.
Display 10.24
Tigers Hitting Statistics 2002 Report
An administrator could use the Transformation Generator wizard to create a
transformation that reads an input table with a certain column structure, enables you
to specify certain options, calculates hitting statistics, and displays the result to the
Output
tab in the Process Designer window. SAS Data Integration Studio users could
then use this transformation in any job.
Assume that the following preparations have been made:
An administrator has created the generated transformation (PrintHittingStats),
and this transformation is available in the Process Library. For more information
about creating generated transformations, see “Maintaining Generated
Transformations” on page 75.
The input to the PrintHittingStats transformation is a table that contains batting
statistics for a baseball team. The columns in the source table are assumed to be
similar to the columns shown in the following display.
Display 10.25
Contents of TigersHitting2002 Table
Search WWH ::
Custom Search