SAS Visual Data Builder
supports staging data. Staging data is a best practice because you
can use SAS Visual Data Builder
to access and transfer data from operational systems once, rather
than frequently interfere with the operational systems and reduce
their performance. Using SAS Visual Data Builder to stage
data can provide the advantage of adding calculated columns when you
stage the data. Like the output table, the staging table is registered
in metadata when you save the query. The physical table for the staging
table is created when you run the query. The physical table is always
replaced with the results of the query.
You cannot specify the
name for a staging table. The name of the output table is used, and
an
__STG (with two underscores)
suffix is applied to the name. The suffix is used for the table name
in metadata. The physical name of the staging table does not include
the suffix.