PowerExchange for SAS User Guide for PowerCenter

Back Next

Source Qualifier Attributes

The metadata extensions tab access the following attributes:

WhereClause: You can enter a selection of rows from the SAS source by using the WhereClause attribute. The WhereClause attribute results in a WHERE statement in SAS.
PreSASCode and PostSASCode exits: The PreSASCode and PostSASCode exits attributes facilitates the invocation of a SAS Macro or a SAS %include statement executed before or after reading 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 SAS Macro.
The WhereClause attribute uses mapping parameters and variables. For example,
PreSASCode exit
and
PostSASCode exit
.