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:
  1. dropping the User-Written Staging transformation onto a job on the Diagram tab of the Job Editor window
  2. (optional) attaching a source table
  3. writing the SAS program to load raw data into SAS tables
  4. attaching target tables
  5. specifying the options and parameters for the transformation, including the location of the staging code
  6. 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 Filethen selectNewthen selectTable.)
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.