Setting the Purge Input Table option of the Aggregation transformation in SAS^® IT Resource Management 3.2 causes a run-time failure, because the libref for the input table is assigned as read-only. Executing the deployed aggregation job produces the following error messages in the SAS^® log:

  ERROR: Write access to member STGnnnnn.tttttttt.DATA is denied.
  NOTE: The SAS System stopped processing this step because of errors.
  NOTE: SAS set option OBS=0 and will continue to check statements.        
  This may cause NOTE: No observations in data set.

  NOTE: Libref ADMIN has been deassigned.
  ERROR: File WORK._ITMS_TABLES2.DATA does not exist.
  ERROR: File WORK._ITMS_TABLES_2.DATA does not exist.
  ERROR: File WORK._ITMS_PERFSTATS.DATA does not exist.
  ERROR: File WORK._ITMS_PERFSTATS.DATA does not exist.

To circumvent these errors, follow these steps:

1. In the SAS IT Resource Management 3.2 client, open the aggregation job to display the process flow diagram.
2. Right-click on the input table to the aggregation transformation, and click Properties.
   1. Select the Physical Storage tab, and note the Physical name of the table. The table name is needed for a later step of the workaround.
   2. Click the Properties button.
   3. Note the Name on the General tab. This Name is the SAS libref that is needed for a later step of this circumvention.
   4. Click the Options tab.
   5. Note the Path Specification in the Selected Items window. The path specification is needed in a later step of the workaround.
   6. Click Cancel and then Cancel again to return to the process flow diagram
3. Right-click on the properties of the Aggregation transformation and navigate to the ITRM Options tab. De-select the option Purge the source table after successful execution of this transformation.

   Click here to see the ITRM Options tab.

4. Select the Precode and Postcode tab, and select the Postcode check box.
5. Using the libref name from Step 2.c, the table name from Step 2.a, and the path specification from Step 2.e, enter the following code into the postcode text box area (for this example the libref is Stglib, the table name is ntcache, and the path specification is c:\datamarts\PurgeInputTableExample\staging.
   %macro clearInput; libname StgLib ‘c:\datamarts\PurgeInputTableExample\staging’; %if (%sysfunc(exist(StgLib.ntcache))) %then %do; data StgLib.ntcache; set StgLib.ntcache(obs=0); run; %end; libname StgLib clear; %mend clearInput; %clearInput;

   Click here to see Precode and Postcode tab.

6. Save the job and deploy it for execution.

1. In the code for the deployed job, note the LIBNAME statement that is used for the input table to the Aggregation transformation.
2. The LIBNAME statement is a write-access version of the LIBNAME statement from Step 1. Note that this code tests to see whether the table tttttttt exists prior to purging the contents. Be sure to specify the correct table name.

Operating System and Release Information

A fix for this issue for SAS IT Resource Management 3.2 is available at: