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
interfere with the operational systems and reduce their performance.
Using SAS Visual Data Builder
to stage data can also 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 for the output table is used and
a
__STG (two underscores)
suffix is applied to the name. The suffix is used for the table name
in metadata. The physical name for the table does not include the
suffix.