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

[knighsson]

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!

[PaigeMiller · Accepted solution]

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

[knighsson]

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

Thank you!

[PaigeMiller]

https://documentation.sas.com/?docsetId=ledsoptsref&docsetTarget=n1p1o2dsuc465nn198ovwdrj9mvy.htm&do...

[knighsson]

Thank you so much!