topic Create dataset with records who's not in dataset1 and dataset2 in New SAS User

Create dataset with records who's not in dataset1 and dataset2

frakje — Thu, 29 Aug 2019 12:47:59 GMT

Hello

I have two datasets. Lets call them dataset1 and dataset2.

I want to create a third dataset who contains records not in both dataset based on my keyvar.

Thank you!

Kind regards Frank

Re: Create dataset with records who's not in dataset1 and dataset2

novinosrin — Thu, 29 Aug 2019 12:54:56 GMT

How can you create a third dataset who contains records not in "both" dataset based on my keyvar.

Are you looking for EXCEPT rule?

Re: Create dataset with records who's not in dataset1 and dataset2

frakje — Thu, 29 Aug 2019 13:01:54 GMT

Let me try to explain.

I have two different datasets with different variables. Both of them contain a Danish 'CPR' number which in this situation is my ID var.

A patient can be in dataset1 and not in dataset2 and opposite. I want to find those patients whos not in both datasets based on my ID var.

In STATA I can use 'merge' and choose those patients where there is no match.

Can I do something similar in sas?

Re: Create dataset with records who's not in dataset1 and dataset2

Kurt_Bremser — Thu, 29 Aug 2019 13:40:53 GMT

See this simplified example:

data one;
input CPR $;
datalines;
123
456
789
;

data two;
input CPR $;
datalines;
000
123
789
;

data check;
merge
  one (in=one)
  two (in=two)
;
by CPR;
if not (one and two);
run;

Both datasets need to be sorted by CPR.