Do not use variable D , make a new variable for that purpose. Not tested. data transposed (drop=A B C D) ; array AA {*} $ A1-A7; array BB {*} $ B1-B7; array CC {*} $ C1-C7; n=0; do until (last.X); set rawdata; by X; n+1; aa(n)= a; bb(n)=b; cc(n)=c; end; output; run;
... View more