Proc transpose:
data have;
input iD $ V1 $ v2 $ V3 $;
datalines;
01 A1 B2 C3
02 O1 P2 Q3
03 X1 Y2 Z3
;
proc transpose data=have out=trans (drop=_name_)
prefix=TheVar
;
by id;
var v1 - v3;
run;
If there are other variables that need to be carried along you need to show a better example.
Please provide data in the form of a data step as shown above and post into a code box opened on the forum using the </> or "running man" icon. Posting the main message window will usually result in text being reformatted and data steps may not run after the forum gets through with them.
