topic Merging two datasets in SAS in SAS Programming

Merging two datasets in SAS

Malathi13 — Tue, 28 Jan 2020 21:59:01 GMT

Hi All,

I have a question with merging two datasets. I want to merge table A with table B and get all the observations in table A that doesn't match with table B. I don't want the matched observations. I have something like this for all matched observations from table A and matching with table B.

DATA matched1; MERGE test1(IN = a) test2;
BY gender age;
IF a;
RUN;

I know this gives all the observations from test1 and those matching from test2. But I want the non-matched one, can I do something like this:

DATA matched1; MERGE test1(IN = a) test2(in=b);
BY gender age;
IF a and not b; /*Not sure if this is the right statement to use in SAS*/
RUN;

Please advise!

Thank you,

Malathi

Re: Merging two datasets in SAS

SASKiwi — Tue, 28 Jan 2020 22:11:06 GMT

Your second DATA step is correct for what you want. There is no harm in testing it for yourself to see if it gives your the results you want.

Re: Merging two datasets in SAS

Ksharp — Wed, 29 Jan 2020 06:27:47 GMT

if not b ;

Re: Merging two datasets in SAS

Malathi13 — Thu, 30 Jan 2020 20:21:26 GMT

Thank you Ksharp!

M