A
job is a collection of SAS tasks that create output. SAS Data Integration Studio uses
the metadata for each job to generate SAS code that reads sources and creates targets
in physical storage.
If you want SAS Data Integration Studio to generate code for a job, you must define
a process flow diagram that specifies the sequence of each
source,
target, and process in a job. In the diagram, each source, target, and process has its own
metadata object.
For example, the following process flow diagram shows a job that reads data from
a source table, sorts the data, and then writes the sorted data to a target table.
The components
of this process flow perform the following functions:
-
ALL_EMP specifies metadata for the source table.
-
Sort specifies metadata for the
sort process.
-
EMP_SORT specifies metadata for the target table.
SAS Data
Integration Studio uses this metadata to generate SAS code that reads
ALL_EMP, sorts this information, and then writes it to the EMP_SORT
table. You can also include temporary output tables and Table Loader
transformations in process flows. For information, see
Working with Default Temporary Output Tables.
Each process in a process flow diagram is specified by a metadata object called a
transformation. In the example, SAS Sort is a transformation. A transformation
specifies how to extract data, transform data, or load data into data stores. Each
transformation that you specify in a process flow diagram generates or retrieves SAS
code. You can specify user-written code for any transformation in a process flow diagram.