If you have set the option DBIDIRECTEXEC and you attempt to use a DELETE statement in a PROC SQL step, no records are deleted from the SAS® Scalable Performance Data Server table.

Here is an example that demonstrates the problem:

libname foo sasspds 'tmp' server=localhost.5400 user='anonymous';

option DBIDIRECTEXEC;

data foo.tab1;
  do x=1 to 10;
    output;
  end;
run;

proc sql;
  delete from foo.tab1 where x=7;
quit;

To circumvent, set the option NODBIDIRECTEXEC.

Select the Hot Fix tab in this note to access the hot fix for this problem.

Operating System and Release Information

A fix for this issue for Base SAS 9.21_M1 is available at: