PowerExchange for SAS User Guide for PowerCenter

Back Next

Table Attributes

Use the

Rename

button on the

Table

tab to access the following table attributes:

Table name: The table name corresponds with the name of the table that you want to read from SAS.
Database name: The database name constitutes a logical grouping of data objects in the Designer. After you import a SAS table, you must set the value of the attribute to the name of the SAS library from which you imported the table.
Business name: The business name corresponds with the SAS label that is assigned to the table.

Use the

Metadata Extensions

tab to access the following attributes:

LibraryName: The LibraryName attribute holds the library name in which PowerCenter writes the SAS table.
SASCode and PostSASCode exits: The SASCode and PostSASCode exits attributes defines a SAS macro or a SAS %include statement to run before or after processing the SAS source object. You must configure the SPI Server to allow the execution of SAS exits. The
autoexec.sas
file is a part of the SPI Server configuration defining the invoking of the SAS macro.
The WhereClause attribute uses mapping parameters and variables. For example, PreSASCode exit and PostSASCode exit.