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.
Process Flow Diagram for a Job That Sorts Data
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.