topic Proc Means Output In Desired Format in SAS Programming

Proc Means Output In Desired Format

Phaneendra — Mon, 07 Mar 2016 19:01:40 GMT

While running proc means, the output is as follows:

But while outputting the dataset using Output= statement, the format is completely different (Only one row with all stats of variables as variable names).

How can i get the output dataset in the same above format? (Need other stats as NMiss & Percentiles etc.)

Re: Proc Means Output In Desired Format

ballardw — Mon, 07 Mar 2016 19:55:51 GMT

Do you need the data or a report table? If you want a readable table in the form you are showing then using ODS to output the table output would be the easiest thing.

Or transpose the output set

Re: Proc Means Output In Desired Format

Phaneendra — Mon, 07 Mar 2016 20:06:31 GMT

@ballardw: I need an output dataset in the same format as the report.(Variable Mean Min Max etc.)

Transposing the output has one row for each Statistic of the variable (Variable1_Mean, Variable1_Min etc.) but i want only one row for each variable and ststistics in columns (Same as report format).

Re: Proc Means Output In Desired Format

Rick_SAS — Mon, 07 Mar 2016 20:51:03 GMT

Use the STACKODSOUTPUT option, which was introduced in SAS 9.3:

/* Use the STACKODSOUTPUT option to get output in a more natural shape */
proc means data=sashelp.cars StackODSOutput 
           N NMISS MEAN STD P25 MEDIAN P75; 
var mpg_city mpg_highway;
ods output summary=out;
run;
 
proc print data=out noobs;run;