When you build an analytical base table (ABT) in SAS^® Customer Analytics for banking or in SAS^® Credit Scoring for Banking, the building process might fail. A message is displayed when you follow this sequence of steps:

1. create a time-based variable
2. mark this variable as an outcome variable
3. in the 'Build ABT' screen, select the required option and date, and click OK

server error
ABT building process failed.

An error message similar to the following one is displayed in the server log:

ERROR: Invalid data set name tmp_lib.<long table name>. 

The problem occurs because the SORT routine tries to create a long table name that is longer than 32 characters. However, table names in SAS^® are limited to 32 characters.

A problem also occurs if you try to use several time-based target variables or filters for the same ABT. In this case, the problem occurs because the underlying generated query considers all option flags in a WHERE condition. An incorrect calculated value results. The WHERE condition instead should use just the respective option flag.

Click the Hot Fix tab in this note to access the hot fix for this issue.

To work around either problem, make the following changes using this sequence of steps:

1. Make a backup of the catalog that is under "<sasroot> …/dabtsrv/cmacro".
2. Open a SAS Program Editor session.

   1. Run this statement.

      %cabinit ; (Run this if you use SAS Customer Analytics for Banking.)
      %csbinit ; (Run this if you use SAS Credit Scoring for Banking.)
   2. Go to "dabt_cm lib", and open the catalog.
   3. Delete the entry for the dabt_create_files_for_rnt macro. If deleting is not allowed, then follow these steps.
      1. Check to see whether any other SAS or SAS^® Data Integration Studio or SAS^® Enterprise Miner™ sessions are running %CABINIT. If yes, then close those sessions.
      2. Restart the object spawner.
      3. Invoke Windows Task Manager. Select the Processes tab. Stop any sassrv process that is running.
      4. Delete the entry for the dabt_create_files_for_rnt macro.
   4. Run the following code:
      option mstored sasmstore=dabt_cm;
   5. Run the attached macro code file, dabt_create_files_for_rnt.sas .

   6. Go to "dabt_cm lib", and open the catalog. Verify that the dabt_create_files_for_rnt entry is created in the catalog.

3. Close the SAS editor. It is mandatory to close the SAS session that was used to modify the catalog.

After completing the steps, you should be able to successfully rebuild the ABT.

Operating System and Release Information

A fix for this issue for SAS Credit Scoring for Banking 5.2 is available at:

A fix for this issue for SAS Customer Analytics for Banking 5.2 is available at: