To write summary statistics to a new data set, use the OUTPUT statement in the MEANS procedure.

When you use the OUTPUT statement, the summary statistics N, MEAN, STD, MIN, and MAX are produced for all of the numeric variables or for all of the variables that are listed in a VAR statement by default. To specify specific statistics to produce, use the statistic=variable(s) option in the OUTPUT statement.

To specify specific statistics in the output data set, you must specify the statistic and then list all of the variables names that contain the value for one or more statistics that are specified in the VAR statement. The variables must be listed in the same order as in the VAR statement. You can specify more than one statistic in the OUTPUT statement.

The following program creates a typical PROC MEANS report and also creates a summarized output data set.

proc means data=clinic.diabetes; 
   var age height weight; 
   class sex; 
   output out=work.sum_gender 
      mean=AvgAge AvgHeight AvgWeight 
      min=MinAge MinHeight MinWeight;  
run;

To see the contents of the output data set, submit a PROC PRINT step.

proc print data=work.sum_gender; 
run;

proc means data=clinic.diabetes noprint;
   var age height weight;
   class sex;
   output out=work.sum_gender
      mean=AvgAge AvgHeight AvgWeight;
run;