SAS Connector > Mappings and mapping tasks with SAS > SAS targets in mappings
  

SAS targets in mappings

To write data to a SAS target, configure a SAS object as aTarget transformation in a mapping.
Specify the name and description of the SAS target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for a SAS target:
Property
Description
Connection
Name of the SAS connection.
Target Type
Type of the SAS target objects available.
You can write data to a single SAS target object. You cannot write data to multiple objects or parameterize the object.
Object
Name of the SAS target object.
Operation
Not applicable for SAS connector.
The following table describes the advanced properties that you can configure for a SAS target:
Property
Description
Load Type
Specifies the operation to write data to SAS objects.
You can select one of the following operations:
  • - Full
  • - Append
  • - Update Else Insert
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 writes data into the SAS target 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 writes data into the SAS target 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.
Index Name (For Update Strategy)
Name of the index that defines the composite key to be used when the load type is Update Else Insert.
Note: This property is applicable only when you select Update Else Insert as the load type.
Forward Rejected Rows
Not applicable for SAS Connector.