Separating out observations for mismatch

r3570 — Thu, 11 May 2023 08:42:42 GMT

I am having 2 datasets as below

dataset 1:

dataset 2:

I want to separate out the records from dataset 1 for which there is no corresponding VISIT in dataset 2.

Need help with the code. Can anybody help ?

Re: Separating out observations for mismatch

Kurt_Bremser — Thu, 11 May 2023 09:46:26 GMT

Since the datasets are already nicely sorted, a MERGE will do:

data want;
merge
  dataset1
  dataset2 (in=ds2)
;
by subjid visit;
if not ds2;
run;