topic Table of Deleted Items? in SAS Programming

Table of Deleted Items?

mcook — Wed, 06 May 2020 15:26:56 GMT

I am trying to delete certain items from a data set, and make a table of the deleted observations for further analysis.

Currently I am doing it as such:

proc sql;

create table Deleted_Items as

select *

from TABLE1

where <conditions>;

quit;

proc sql;

delete *

from TABLE1

where <conditions>;

quit;

Is it possible to do this in a single step?

Shmuel — Wed, 06 May 2020 15:48:54 GMT

Use a sas data step instead sql

data saved deleted;
  set have;
      if <condition> then output saved;
     else output deleted;
 run;

Kurt_Bremser — Wed, 06 May 2020 16:07:34 GMT

@mcook wrote:

Is it possible to do this in a single step?

Not with SQL, but with a data step as @Shmuel suggested.