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

You could try something like:   data my_fruit(drop=_count); set my_fruit; by fruit; retain _count; if first.fruit then _count=count; diff=abs(_count-count); run;     This returns: fruit count day diff apples 500 1 0 apples 300 3 200 apples 505 5 5 apples 487 7 13 oranges 36 1 0 oranges 39 5 3 oranges 42 7 6 pears 17 1 0 pears 16 2 1 pears 13 3 4 pears 21 5 4 pears 27 6 10   ... View more