User-Written Staging Transformations

Overview

The SAS IT Resource Management User-Written Staging transformation provides a place for you to enter your staging code for a data source. The process consists of the following steps:

dropping the User-Written Staging transformation onto a job on the Diagram tab of the Job Editor window
(optional) attaching a source table
writing the SAS program to load raw data into SAS tables
attaching target tables
specifying the options and parameters for the transformation, including the location of the staging code
generating the code and running the job

When the code is generated, macros and macro variables that might be useful in the user-written code are also generated. After reviewing the generated code, you can save the job and run it to create the physical tables. However, before doing so, you must create the metadata for the target table by invoking the New Table wizard. (To do so, from the SAS Data Integration Studio menu, select File

New

Table.)

For more guidance about the processes that enable you to create user-written staging transformations, see Guidelines for Processing Data with User-Written Staging Transformations. This topic also includes information about aggregating, creating information maps, and reporting on the data that is produced by your user-written staging code.

The remainder of this chapter consists of the four following topics: