It can be done using proc transpose too. proc transpose data=have out=dummy; by subjid phase ; var ldosedt fdosedt ; run; data dummy; set dummy; VAR=catx('_',_name_,phase); run; proc transpose data=DUMMY out=WANT (drop=_NAME_); by subjid; id VAR; run;
... View more