I like to transponse the following dataset called student, which works so far. input n ID Year$ rate; datalines; 1 1 2010 1 2 1 2011 2 3 1 2012 1 4 2 2010 4 5 2 2011 3 6 2 2012 2 7 3 2012 2 with the procedure proc transponse data=student; out=Zeugnis (drop= _NAME_) ; by ID; var rate; id Year; run; Result looks like this. obs ID _2010 _2011 _2012 1 1 1 2 1 2 2 4 3 2 3 3 . . 2 Now I would like to add the Average colum to the end the display the average rate for each ID. ID _2010 _2011 _2012 Average 1 1 1 2 1 1.66 2 2 4 3 2 3 3 3 . . 2 2 Could you sugest a solution for this, if possible a simple line in the transponse procedure? I tried to add this line, but it doies not work: AVERAGE=mean(rate); Thanks!
... View more