libname rawfile 'c:\'; run; proc sort data=rawfile.man; by id; run; data ROWOBS; set rawfile.man; by id; array x_var(3) X1-X3 ; array y_var(3) Y1-Y3 ; array z_var(3) Z1-Z3; if first.id then do i = 1 to 3; x_var(i) = .; y_var(i) = .; z_var(i) = .; end; j = time; x_var(j) = x; y_var(j) = y; z_var(j) = z; if last.id then output; retain x1-x3 y1-y3 z1-z3; drop i j time x y z; run; ... View more

thank you very much. let me study it first. really appreciate your help ... View more

here is my raw data file, in my google drive https://drive.google.com/open?id=0BzqllIWlzJosWGZSdmkzZ0RIeDA ... View more

thank you for your help and good answer. however, marco, proc transpose are not allowed. i can only use array data step to do it. sorry . ... View more