Dataset a: Dataset b: ID Recpos AE ID Rec AE_adj 001 1 fever,chills 001 1 rejection,fever,chills 001 2 artery rupture 002 1 rejection 002 0 ID-Subject ID-Character ID-Subject ID-Character Recpos-Record-Numeric Rec-Record-Numeric AE-AEterm-character AE_adj-AEterm-character Output Expected: ID Recpos Rec AE AE_adj 001 1 1 fever,chills rejection,fever,chills 001 2 artery rupture 002 0 002 1 rejection Output that I got after running the below code: ID Recpos AE AE_adj 001 1 fever,chills rejection,fever,chills 001 2 artery rupture 002 0 002 1 rejection Can you please suggest what is going wrong with in the merging? Is it the renaming thing that is causing this issue? Thank you, data step_01_a;
set a;
keep ID Recpos AE;
run;
proc sort data = step_01_a; by ID Recpos; run;
data step_01_b;
set b;
keep ID Rec AE_adj;
run; proc sort data=step_01_b out=step_01_b(rename=(Rec=Recpos)); by ID Recpos; run; data final; merge step_01_a(in=a) step_01_b(in=b); if a or b; run;
... View more