1. Study Setup Guide
  2. Create custom programs, listings, and filters, and set up reference data
  3. Create custom programs
  4. Sample programs that populate auxiliary columns with the source surrogate key

Sample programs that populate auxiliary columns with the source surrogate key

The following example SAS and PL/SLQL programs are straightforward ones that you could create in the user interface using a Transformation Type of Direct and Join, respectively. However, they show how to populate auxiliary keys in the target table with the surrogate key value from the source tables.

Parent topic: Create custom programs