proc sort data=ds1; proc sort data=ds2; proc sort data=ds3; by PTID; run; data ds4; merge d1 (in=inds1) d2 (in=inds2) d3 (in=inds3); by PTID; if inds1 + inds2 + inds3 = 2; MRNnew=compress(MRN,'7 9 'M''); run; title "Merged dataset"; proc print data=ds4; run; ... View more

right* ... View more

That code does not give me the write output. ... View more

A table which has PTID's which are common to exactly 2 datasets out of the three. ... View more

Common variable is PTID ... View more

this is the data I have ... View more

data ds1 ; input PTID MRN $9. ; datalines ; 1 514779-MT 2 M200-8X 3 999-M 4 79750 ; data ds2 ; input PTID WBC ; datalines ; 4 450 3 340 2 . 5 870 6 . ; data ds3 ; input PTID WEIGHT ; datalines ; 2 157 1 163 4 . 6 130 ; ... View more

I have 3 datasets with different variables. I have to merge those 3 datasets with a common variable. And the observations for this variable should be present in exactly 2 datasets out of the 3. Does this help to provide a solution? ... View more