topic Re: how to get non matching observations from one data set only in SAS Programming

how to get non matching observations from one data set only

hwangnyc — Fri, 01 Sep 2017 13:21:07 GMT

Hi everyone,

Building off of this post:

https://communities.sas.com/t5/SAS-Procedures/how-to-get-non-matching-observations/m-p/97985#M27616

Using this code:

data Match Nomatch;
     merge a (in=ina) b (in=inb);
     by no;
     if ina and inb then output match;
     else output Nomatch;
run;

I would like to output a data set that includes observations that did not match dataset "a" only. Any suggestions on where to start?

Re: how to get non matching observations from one data set only

gamotte — Fri, 01 Sep 2017 13:25:07 GMT

if not ina ?

Re: how to get non matching observations from one data set only

hwangnyc — Fri, 01 Sep 2017 13:42:29 GMT

How would you code that?

Re: how to get non matching observations from one data set only

gamotte — Fri, 01 Sep 2017 13:50:50 GMT

data Match Noamatch Nobmatch;
     merge a (in=ina) b (in=inb);
     by no;
     if ina and inb then output match;
	 else if not ina then output Noamatch;
	 else output Nobmatch;
run;

Re: how to get non matching observations from one data set only

hwangnyc — Fri, 01 Sep 2017 14:10:21 GMT

Thank you!