Try this one. Or if you are interested about tranposing data by DATA STEP. Refer to the paper of Arthur.T and me . http://support.sas.com/resources/papers/proceedings13/538-2013.pdf data have ;
infile cards truncover ;
input index name $ result class $20.;
cards;
1 amit 36 physics
1 nitu 28 chemistry
1 ketu 28 biology
2 amit 98 physics
2 nitu 78 chemistry
2 ketu 28 biology
3 amit 74 physics
3 nitu 93 chemistry
3 ketu 92 biology
;
run;
proc sql;
select distinct catt('have(where=(index=',index,' and class="',class,'") rename=(result=_',index,'))') into : list separated by ' ' from have;
quit;
data want(drop=class index);
merge &list ;
by name class;
n+1;
run;
Xia Keshan
... View more