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 default statistics
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
outputs observations for only the highest _TYPE_ value
outputs _TYPE_ as binary character values
outputs the maximum taste score to 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

The OUT= output data set contains only observations for the combination of both class variables, Flavor and Layers. Therefore, _TYPE_ contains the binary character string 11. The observations are ordered by ascending frequency of Flavor. The missing value in Layers is a valid value for this class variable. PROC MEANS excludes the observation with the missing flavor because it an invalid value for Flavor.

Chapter Contents
Previous
Next
Top of Page