Table of Deleted Items?

[mcook]

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 · Accepted solution]

Use a sas data step instead sql

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

[Kurt_Bremser]

---

@mcook wrote:

Is it possible to do this in a single step?  

---

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