topic Re: Duplicate entries in datasets in SAS Programming

Duplicate entries in datasets

Walternate — Fri, 17 May 2013 19:25:42 GMT

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!

Re: Duplicate entries in datasets

vxhong17 — Fri, 17 May 2013 19:47:18 GMT

Hi,

You can use "proc sql" for your purpose,

proc sql;

title 'B EXCEPT A';

select * from sql.b

except

select * from sql.a;

Re: Duplicate entries in datasets

Reeza — Fri, 17 May 2013 19:47:53 GMT

Try the exists/not exists condition:

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