This PROC MEANS step analyzes the data for the one-way combination of
the class variables and across all observations. It creates an output data
set that includes variables for the total and average amount of money raised.
The data set also includes new variables for the top three amounts of money
raised, the names of the three students who raised the money, the years when
the students raised the money, and the schools that the students attended.
For a detailed explanation of a similar PROC MEANS step, see the example "Identifying
the Top Three Extreme Values with the Output Statistics" in the documentation
for the MEANS procedure in SAS Procedures Guide.
proc means data=Charity descendTypes charType noprint;
class School Year;
var moneyRaised;
types () School year;
output out=top3list sum= mean=
idgroup ( max(moneyRaised) out[3](moneyRaised name school year)= )
/ autoname;
run;