The MEANS Procedure

Example 10: Computing Output Statistics with Missing Class Variable Values

Procedure features:

PROC MEANS statement options:

	CHARTYPE
	NOPRINT
	NWAY

CLASS statement options:

	ASCENDING
	MISSING
	ORDER=

OUTPUT statement

Other features:

PRINT procedure

Data set:

CAKE

This example

suppresses the display of PROC MEANS output
considers missing values as valid level values for only one class variable
orders observations in the output data set by the ascending frequency for a single class variable
stores observations for only the highest _TYPE_ value
stores _TYPE_ as binary character values
stores the maximum taste score in a new variable
displays the output data set.

Program

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

proc means data=cake chartype nway noprint;

   class flavor /order=freq ascending;
   class layers /missing;

   var TasteScore;

   output out=cakestat max=HighScore;
run;

proc print data=cakestat;
   title 'Maximum Taste Score for Flavor and Cake Layers';
run;

Output

                 Maximum Taste Score for Flavor and Cake Layers                1

                                                               High
            Obs    Flavor       Layers    _TYPE_    _FREQ_    Score

             1     Rum             2        11         1        72 
             2     Spice           2        11         2        83 
             3     Spice           3        11         1        91 
             4     Vanilla         .        11         1        84 
             5     Vanilla         1        11         3        94 
             6     Vanilla         2        11         2        87 
             7     Chocolate       .        11         1        84 
             8     Chocolate       1        11         5        85 
             9     Chocolate       2        11         3        92

Top of Page