Default Conditions, Actions, and Conditional Action Sets

Overview

SAS Data Integration Studio provides a number of default conditions, actions, and condition action sets. These are displayed in the Inventory tree and the Folders tree. Typically, however, you do not interact with these objects in the tree view. Instead, you use the Status Handling tab in the property windows of jobs and transformations.
Note: If you want to add user-defined condition templates, action templates, or condition action set templates, contact your SAS representative.

Default Conditions

All of the default conditions are listed in the following table and in the Condition folder in the Inventory tree. Only those conditions that are valid for a job or for a specific kind of transformation are displayed on the Status Handling tab.
Default Conditions
Condition
Description
Data Exception
An exception occurred as the Data Validation transformation processed data.
Data Modified
The transformation modified data.
Errors in Process
There was an error in a process.
Errors
This checks for return code > 4.
Lookup Failed
The lookup value was not found.
Lookup Table Missing
The lookup table is missing.
No Lookup Rows
There are no rows in the lookup table.
Send Job Status
The job status table is created.
Successful
This checks for return code=0.
Successful RC=1, RC=2. and RC=3
This condition is not used.
Table Created
A table is created in physical storage.
Table Does Not Exist
Table does not exist in physical storage.
Table Dropped
The table is deleted.
Table Not Match Meta
This identifies when the table does not match the metadata.
Table Truncated
The table is truncated.
Warnings
This checks for return code > 3.

Default Actions

You can specify an action that should be performed when a certain condition is met. When you select a condition on the Status Handling tab, only those actions that are valid for that condition are available to be selected. The Input column in the following table describes the values that are required by some actions.
Default Actions
Action
Description
Input
Abort
Terminates the job or transformation.
None.
Abort After Looping
Completes all of the processes in the loop and then terminates the job.
None.
Abort All Processes
Terminates all of the currently executing and remaining processes.
None.
Abort Remaining
Terminates all of the remaining processes after the current process executes.
None.
Add Row to Error Table
Adds a row to an error table for a Lookup transformation.
None.
Add Row to Exception Table
Adds a row to an exception table, as specified by the transformation.
None.
Custom
Calls SAS code to provide user-defined status handling for a job or transformation. Examples include SAS code added to the Precode and Postcode tab in a job or transformation, or a macro in a SAS Autocall library.
In the Custom Code field, enter a call to the user-defined code. One example is the following call to a macro in a SAS Autocall library: %sendcustom;
Do Not Create Report
Prevents the creation of an exception report.
None.
Email Report
Sends an exception report to the specified email address.
E-mail address.
Save Report
Saves the exception report to the specified location.
Location for the exception report.
Save Table
Saves status messages to a table. Consecutive messages are appended to the table with a timestamp.
Table name in the LIBREF.DATASET SAS format. The libref must be assigned before the job or transformation executes.
Send Email
Sends an email message that you specify.
One or more recipient email addresses and a message in the options window. To specify more than one email address, enclose the group of addresses in parentheses, enclose each address in quotation marks, and separate the addresses with a space, as in user1@domain.com and user2@domain.com. Any text in the Message field that includes white space must be enclosed by single quotation marks so that the mail is processed correctly.
Send Entry to Data Set
Saves status messages to a SAS data set. Consecutive messages are appended to the data set with a timestamp.
Data set name in the LIBREF.DATASET SAS format. The libref must be assigned before the job or transformation executes.
Send Entry to File
Sends text to the specified filename.
Physical path to a file; text of the message.
Send Event
If an event broker is configured, this action sends a status message to the event broker, which sends the message to applications that have subscribed to the broker. The subscribing applications can then respond to the status of the SAS Data Integration Studio job or transformation.
For details about the options for the Send Event action, see the SAS Data Integration Studio Help for the Event Options window.
Send Job Status
Updates the job status table with a record when the current job completes.
Data set name in the LIBREF.DATASET SAS format. The libref must be assigned before the job or transformation executes.
Set Target Column Value
Sets the target column to the specified value; accessible from the Lookups tab of the Lookup transformation property window.
SAS expression.
Set Target Column Value to Missing
Sets the target column value to missing; accessible from the Lookups tab of the Lookup transformation property window.
None.
Skip the Record
Skips a record that has an error.
None.

Conditional Action Sets

All of the default action sets are listed in the following table and in the Conditional Action Sets folder in the Inventory tree. Typically you do not interact with these sets. They provide status handling for the standard SAS Data Integration Studio transformations.
Default Conditional Action Sets
Conditional Action Sets
Description
Data Exception
Condition: Data Exception
Actions: None, Send Email, Send Entry to Dataset, Send Entry to File, Send Event, Do not create report, Email Report, Save Report. Save Table
Send Job Status
Condition: Send Job Status
Actions: None, Send Job Status
Set Data Modified
Condition: Data Modified
Actions: None, Custom, Send Email, Send Entry to Dataset, Send Entry to File, Send Event
Set Error in Process
Condition: Error in Process
Actions: None, Custom, Send Email, Send Entry to Dataset, Send Entry to File, Abort All Processes, Abort Remaining, Abort After Looping, Send Event
Set Errors
Condition: Errors
Actions: None, Custom, Send Email, Send Entry to Dataset, Send Entry to File, Abort, Send Event
Set Lookup Not Found
Condition: Lookup Failed
Actions: None, Abort, Add Row to Error Table, Add Row to Exception Table, Set Target Column Value, Set Target Column Value to Missing, Skip the Record
Set Lookup Table Missing
Condition: Lookup Table Missing
Actions: None, Abort, Add Row to Error Table, Add Row to Exception Table, Set Target Column Value, Set Target Column Value to Missing, Skip the Record
Set Lookup Table Missing Records
Condition: No Lookup Rows
Actions: None, Abort, Add Row to Error Table, Add Row to Exception Table, Set Target Column Value, Set Target Column Value to Missing, Skip the Record
Set Successful
Condition: Successful
Actions: None, Custom, Send Email, Send Entry to Dataset
Set Successful return code =1
Not used
Set Successful return code =2
Not used
Set Successful return code =3
Not used
Set Table Created
Condition: Table Created
Actions: None, Custom, Send Email, Send Entry to Dataset
Set Table Different
Condition: Table Different
Actions: None, Custom, Send Email, Send Entry to Dataset, Send Entry to File, Send Event
Set Table Does Not Exist
Condition: Table Does Not Exist
Actions: None, Custom, Send Email, Send Entry to Dataset, Send Entry to File, Send Event
Set Table Dropped
Condition: Table Dropped
Actions: None, Custom, Send Email, Send Entry to Dataset, Send Entry to File, Send Event
Set Table Truncated
Condition: Table Truncated
Actions: None, Custom, Send Email, Send Entry to Dataset, Send Entry to File, Send Event
Set Warnings
Condition: Warnings
Actions: None, Custom, Send Email, Send Entry to Dataset, Send Entry to File, Send Event