Overriding Locations in the Exception Transformation

For the Exception transformation, you can override these locations:
  • the input library from which the input table is read
  • the output library to which any output tables are written
  • the SAS Content Server path to which report content is written
For the input and output libraries, you can override the library that was previously specified in metadata by predefining a SAS library with the same matching libref. Input and output libraries should already exist, and the input library should contain the appropriate input table. In addition, permissions should be set so that the appropriate users can read from and write to the appropriate locations.
If you specify a value for the SAS macro variable OVERRIDEREPOSITORYFOLDERPATH, the report content is written to that location in the SAS Content Server repository. You can specify any or all of these override locations. The SAS Content Server repository path to use should already exist. In addition, permissions should be set so that the appropriate users can read from and write to that path.
For example, you might have a job that contains an Exception transformation that is deployed as DT_Perf_Sentry_1_Exception.sas. In this case, the following program could be used to override the input and output SAS libraries and the SAS Content Server path to which report content is written. If the job is defined in metadata to read a table from a SAS library with libref AGG4534 and to write exception tables to a SAS library with libref EXP1305, then the two LIBNAME statements cause the job to read from and write to the specified alternate locations instead.
LIBNAME AGG4534 BASE "c:\users\me\datamarts\DTPerf1\DTPerfSentry1\Alternate"; 
LIBNAME EXP1305 BASE "c:\users\me\datamarts\DTPerf1\Exception\Alternate "; 
%LET overrideRepositoryFolderPath=%str(/SASContentServer/repository/default
                                  /sasdav/My Alternate Location);             
%INCLUDE ‘DT_Perf_Sentry_1_Exception.sas’; 
Note: If the deployed job contains multiple Exception transformations, these overridden locations, if specified, are used for all such transformations. To override the location of exception output tables, make sure that you do not accidentally overwrite output tables from multiple transformations.