Property | Description |
|---|---|
Connection | Name of the SAS source connection. Select a source connection, or click New Parameter to define a new parameter for the source connection. |
Source Type | Type of the SAS source objects available. Select Single Object. You cannot read data from multiple objects or parameterize the object. |
Object | Name of the SAS source object. |
Filter | Configure a simple filter or an advanced filter to remove rows at the source. You can improve efficiency by filtering early in the data flow. A simple filter includes a field name, operator, and value. Use an advanced filter to define a more complex filter condition, which can include multiple conditions using the AND or OR logical operators. |
Property | Description |
|---|---|
Trace | Indicates whether the SAS Connector must toggle verbose logging. |
Compress | Compresses the data into the SAS datasets. |
PreSASCode | Specifies a SAS Macro or a SAS %include statement to be executed before the Secure Agent reads data from the SAS source object. Ensure that the SPI Server is configured to allow the execution of SAS exits. To invoke a SAS Macro, you must define the SAS Macro in the autoexec.sas file in the SPI Server configuration. |
PostSASCode | Specifies a SAS Macro or a SAS %include statement to be executed after the Secure Agent reads data from the SAS source object. Ensure that the SPI Server is configured to allow the execution of SAS exits. To invoke a SAS Macro, you must define the SAS Macro in the autoexec.sas file in the SPI Server configuration. |
Table Name | The name of the SAS table where you want to write the data. |
Library Name | The library name associated with the SAS table. |