The MEANS Procedure

Example 11: Identifying an Extreme Value with the Output Statistics

Procedure features:

CLASS statement

OUTPUT statement options:

	statistic keyword
	MAXID

Other features:

PRINT procedure

Data set:

CHARITY

This example

identifies the observations with maximum values for two variables
creates new variables for the maximum values
displays the output data set.

Program

options nodate pageno=1 linesize=80 pagesize=60;

proc means data=Charity n mean range;

   class School Year;

   var MoneyRaised HoursVolunteered;

   output out=Prize maxid(MoneyRaised(name) 
          HoursVolunteered(name))= MostCash MostTime
          max= ;
   title 'Summary of Volunteer Work by School and Year';
run;

proc print data=Prize;
   title 'Best Results: Most Money Raised and Most Hours Worked';
run;

Output

The first page of output shows the output from PROC MEANS with the statistics for six class levels: one for Monroe High for the years 1992, 1993, and 1994; and one for Kennedy High for each of the three years.

The output from PROC PRINT shows the maximum MoneyRaised and HoursVolunteered values and the names of the students who are responsible for them. The first observation contains the overall results, the next three contain the results by year, the next two contain the results by school, and the final six contain the results by School and Year.

Chapter Contents
Previous
Next
Top of Page

The first page of output shows the output from PROC MEANS with the statistics for six class levels: one for Monroe High for the years 1992, 1993, and 1994; and one for Kennedy High for each of the three years.

The output from PROC PRINT shows the maximum MoneyRaised and HoursVolunteered values and the names of the students who are responsible for them. The first observation contains the overall results, the next three contain the results by year, the next two contain the results by school, and the final six contain the results by School and Year.