You could use proc sql:   proc sql; create table table01 as select * from table01 where name not in (select name from table02); quit;  If you'd like to report on what rows would be deleted, you could just run the inversed query beforehand:     proc sql; create table table01 as select * from table01 where name in (select name from table02); quit;     ... View more