Duplicate entries in datasets

[Walternate]

Hello all.

I am working with 2 datasets: A and B. Everyone from dataset A is also in dataset B. How can I direct SAS to delete from dataset B everyone who is also in dataset A?

Thanks!

[vxhong17]

Hi,

You can use "proc sql" for your purpose,

proc sql;

  title 'B EXCEPT A';

  select * from sql.b

  except

  select * from sql.a;

[Reeza]

Try the exists/not exists condition:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473688.htm