Hi,' I tried in some other logic using transpose,,...but check whether it is applicable to our large....no of columns... data have; infile datalines; input ID var1-var23; datalines; 1 10 20 25 10 8 30 23 34 55 20 23 45 67 99 12 33 44 55 66 67 78 12 88 455 2 20 30 35 8 10 25 23 12 33 45 45 55 33 12 22 33 66 89 76 57 47 24 15 27 ; run; proc transpose data=have out=out1; by id; run; data out2; set out1; do _n_= 5 to 20; /*Here please insert as 10 to ....last column*****/ _n_=_n_+5; /****Here _n_+10****/ output; end; output; run; data allu.final; set allu.out2; category=compress(_name_,,'kf'); _name_=compress(_name_,,'kd'); run;
... View more
