SUPPORT / SAMPLES & SAS NOTES
Problem Note 55670: The &SYSERR macro variable returns a value of 0 when you use the DATASETS procedure with a DELETE statement to delete a SAS® SPD Server table
 |  |  |  |  |
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=0The &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:
ERROR: File SPDSLIB.TBL.DATA cannot be deleted because it is locked by another user.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Client | Microsoft® Windows® for x64 | 4.53 | 4.53 HF6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.53 | 4.53 HF6 | ||||
| Microsoft Windows Server 2008 for x64 | 4.53 | 4.53 HF6 | ||||
| Windows 7 Enterprise x64 | 4.53 | 4.53 HF6 | ||||
| 64-bit Enabled AIX | 4.53 | 4.53 HF6 | ||||
| 64-bit Enabled HP-UX | 4.53 | 4.53 HF6 | ||||
| 64-bit Enabled Solaris | 4.53 | 4.53 HF6 | ||||
| HP-UX IPF | 4.53 | 4.53 HF6 | ||||
| Linux for x64 | 4.53 | 4.53 HF6 | ||||
| Solaris for x64 | 4.53 | 4.53 HF6 | ||||