/**********************************************************************
 * example on proc transpose 
 * Peng Zeng 
 * 08-06-2020
 **********************************************************************/

data ex; 
   input class $ student $ test score percent; 
datalines; 
S123  aa  1  80  21
S123  aa  2  90  23
S124  bb  1  85  25
S124  bb  2  95  28
;

proc print data = ex; run;

proc transpose data = ex out = ex2 prefix = test name = type;
   var score percent;  
   by class student;
run;

proc print data = ex2; run;

/**********************************************************************
 * THE END
 **********************************************************************/