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.