If you use the DATASETS procedure with a DELETE statement to delete a SAS SPD Server table while the table is in use, the &SYSERR macro variable might return a value of 0. Here is an example:

14   proc datasets lib=spdslib;
NOTE: Writing HTML Body file: sashtml.htm
15    delete tbl;
16   quit;

NOTE: Deleting SPDSLIB.TBL (memtype=DATA).
NOTE: File SPDSLIB.TBL (memtype=DATA) cannot be deleted because it is in use.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           1.87 seconds
      cpu time            1.10 seconds

17
18   %put SYSERR=&syserr;
SYSERR=0

The &SYSERR macro variable is set to 0 incorrectly.

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

After you apply the Hot Fix, you should see that the following error message and SYSERR are set to 1008:

Operating System and Release Information

A fix for this issue for Scalable Performance Data Server 4.52 is available at:

A fix for this issue for SAS Scalable Performance Data Server 4.53 is available at:

A fix for this issue for SAS Scalable Performance Data Server 5.1 is available at: