Dear All, I have created series of macro variable for all expected visits using proc sql. data visit; input folder $50.; cards; D8 D15 D29 D43 D57 ; run; proc sql; select count(folder) into :numrows from visit; quit; %let numrows=&numrows; proc sql; select folder into :visit1 - :visit&numrows from visit; quit; %put _user_; data master; input id $50. folder $50.; cards; 1 D8 1 D15 1 D29 1 D43 2 D15 2 D29 2 D43 2 D5 3 D8 3 D15 3 D29 3 D43 3 D5 ; run; Using macro variables created previously, add visit columns to lab data in case not present. [Do not use data merge to achieve this result], use macro concept.
... View more