SAS Support environment variables in DataStage

These environment variables are concerned with DataStage® interaction with SAS.

APT_HASH_TO_SASHASH environment variable in DataStage

Set the APT_HASH_TO_SASHASH environment variable so that all appropriate instances of hash to be replaced by sashash.

The DataStage hash partitioner contains support for hashing SAS data. In addition, DataStage provides the sashash partitioner that uses an alternative nonstandard hashing algorithm. Setting the APT_HASH_TO_SASHASH environment variable causes all appropriate instances of hash to be replaced by sashash. If the APT_NO_SAS_TRANSFORMS environment variable is set, APT_HASH_TO_SASHASH has no effect.

APT_NO_SASOUT_INSERT environment variable in DataStage

Set the APT_NO_SASOUT_INSERT environment variable to selectively disable the sasout operator insertions. It maintains the other SAS-specific transformations.

APT_NO_SAS_TRANSFORMS environment variable in DataStage

Set the APT_NO_SAS_TRANSFORMS environment variable to prevent DataStage from making certain types of SAS-specific component transformations.

DataStage automatically performs certain types of SAS-specific component transformations, such as inserting an sasout operator and substituting sasRoundRobin for RoundRobin. Set APT_NO_SAS_TRANSFORMS to prevent DataStage from making these transformations.

APT_SAS_ACCEPT_ERROR environment variable in DataStage

Set the APT_SAS_ACCEPT_ERROR environment variable prevents the SAS-interface operator from closing when a SAS procedure causes SAS to exit with an error.

The default behavior is for DataStage to close the operator with an error.

APT_SAS_CHARSET_ABORT environment variable in DataStage

Set the APT_SAS_CHARSET_ABORT environment variable to cause a SAS-interface operator to stop if DataStage encounters a ustring in the schema and the -sas_cs option and the APT_SAS_CHARSET environment variable are not set.

APT_SAS_COMMAND environment variable in DataStage

Set the APT_SAS_COMMAND environment variable to override the $PATH directory for SAS with an absolute path to the basic SAS executable file.

An example path is:


/usr/local/sas/sas8.2/sas

APT_SASINT_COMMAND environment variable in DataStage

Set the APT_SASINT_COMMAND environment variable to override the $PATH directory for SAS with an absolute path to the International SAS executable file.

An example path is:


/usr/local/sas/sas8.2int/dbcs/sas

APT_SAS_DEBUG environment variable in DataStage

Set the APT_SAS_DEBUG environment variable to set debug in the SAS process that is coupled to the SAS stage.

Messages appear in the SAS log and can be copied into the DataStage log. Use APT_SAS_DEBUG=1, APT_SAS_DEBUG_IO=1, and APT_SAS_DEBUG_VERBOSE=1 to get all debug messages.

APT_SAS_DEBUG_IO environment variable in DataStage

Set the APT_SAS_DEBUG_IO environment variable to set input/output debug in the SAS process that is coupled to the SAS stage.

Messages appear in the SAS log and can be copied into the DataStage log.

APT_SAS_DEBUG_LEVEL environment variable in DataStage

Set the APT_SAS_DEBUG_LEVEL environment variable to specify the level of debugging messages to output from the SAS driver.

APT_SAS_DEBUG_LEVEL takes the following syntax:


APT_SAS_DEBUG_LEVEL=[0-3]

The values of 1, 2, and 3 duplicate the output for the -debug option of the SAS operator:


no, yes, and verbose.

APT_SAS_DEBUG_VERBOSE environment variable in DataStage

Set the APT_SAS_DEBUG_VERBOSE environment variable to set verbose debug in the SAS process that is coupled to the SAS stage.

Messages appear in the SAS log and can be copied into the DataStage log.

APT_SAS_S_ARGUMENT environment variable in DataStage

Set the APT_SAS_S_ARGUMENT environment variable to specify a value for the SAS -s argument.

By default, DataStage runs SAS with -s 0. When APT_SAS_S_ARGUMENT is set, its value is used instead of 0. Consult the SAS documentation for details.

APT_SAS_SCHEMASOURCE_DUMP environment variable in DataStage

Set the APT_SAS_SCHEMASOURCE_DUMP environment variable if you are using SAS Schema Source to cause the command line to be written to the log when executing SAS.

You use the APT_SAS_SCHEMASOURCE_DUMP environment variable to inspect the data contained in a -schemaSource. Set this environment variable if you are getting an error when specifying the SAS data set containing the schema source.

APT_SAS_SHOW_INFO environment variable in DataStage

Set the APT_SAS_SHOW_INFO environment variable to display the standard SAS output from an import or export transaction.

The SAS output is normally deleted because a transaction is usually successful.

APT_SAS_TRUNCATION environment variable in DataStage

Set the APT_SAS_TRUNCATION environment variable to specify sasin and sas operators determine how to truncate a ustring value to fit into an SAS char field.

APT_SAS_TRUNCATION takes the following syntax:


APT_SAS_TRUNCATION ABORT | NULL | TRUNCATE

Because a ustring of n characters does not fit into n characters of a SAS char value, the ustring value must be truncated beyond the space pad characters and \0.

The sasin and sas operators use APT_SAS_TRUNCATION to determine how to truncate a ustring value to fit into a SAS char field. TRUNCATE, which is the default, causes the ustring to be truncated; ABORT causes the operator to stop; and NULL exports a null field. For NULL and TRUNCATE, the first five occurrences for each column cause an information message to be issued to the log.