Databases Reference
In-Depth Information
Example: Creating a Generated Transformation
Preparation
For this example, assume that a SAS data set named TigersHitting2002 contains
batting statistics for a baseball team. The following display shows the content and
structure of this data set.
Display 6.1
Contents of Data Set TigersHitting2002
The goal is to create a transformation template that takes a SAS data set as input
and produces a report. The report displays a user-defined title, displays a user-defined
set of columns, and calculates the sum of the values in one column of the table. The
following display shows the kind of output that is desired.
Display 6.2
Tigers Hitting Statistics 2002
Assume the following about the current example:
The main metadata repository is under change-management control. In this
example, however, assume that an administrator is creating the new template, so
the template would be added to directly to the Process Library tree, without
having to be checked in. For details about change management, see “Working with
Change Management” on page 113.
You have selected a default SAS application server for SAS Data Integration
Studio, as described in “Selecting a Default SAS Application Server” on page 96.
Start SAS Data Integration Studio and Open the Appropriate Metadata
Profile
Follow these steps to begin work in SAS Data Integration Studio:
1
Start SAS Data Integration Studio.
Search WWH ::
Custom Search