topic compare two datasets and create a new dataset that only has different observations in New SAS User

compare two datasets and create a new dataset that only has different observations

knighsson — Sat, 18 Jul 2020 15:17:53 GMT

Hi,

I have two datasets with different variables. But both datasets have a variable "sequence number" to represent observations. I want to know how many observations are different from each other (or how many observations are not in dataset 1 but in dataset 2). I also want to create a new dataset with variables in dataset 2.

Dataset 1:

seqn variable1 variable 2

1 3 2

3 4 2

......

dataset 2:

seqn variable3 variable 4

1 1 4

2 2 3

3 2 3

......

dataset I want:

seqn variable3 variable 4

2 2 3

......

Thank you!

Re: compare two datasets and create a new dataset that only has different observations

PaigeMiller — Sat, 18 Jul 2020 15:57:41 GMT

data want;
    merge dataset1(in=in1) dataset2(in=in2);
    by seqn;
    if in2 and not in1;
run;

Re: compare two datasets and create a new dataset that only has different observations

knighsson — Sat, 18 Jul 2020 18:53:41 GMT

Thank you, could you explain What (in=in1) means?

Thank you!

Re: compare two datasets and create a new dataset that only has different observations

PaigeMiller — Sat, 18 Jul 2020 19:59:33 GMT

https://documentation.sas.com/?docsetId=ledsoptsref&docsetTarget=n1p1o2dsuc465nn198ovwdrj9mvy.htm&docsetVersion=9.4&locale=en

Re: compare two datasets and create a new dataset that only has different observations

knighsson — Sun, 19 Jul 2020 04:19:34 GMT

Thank you so much!