topic Re: proc means with stackodsoutput option in SAS Programming

proc means with stackodsoutput option

Ronein — Thu, 09 Aug 2018 06:21:15 GMT

Hello

I am using in proc means with stackodsoutput option.

I want to ask please why when I don't use NWAY I don't get a row for grand summaries.

Please see the code

/****Using nway*****/
ods output summary=with_stackods  (drop=_control_);
proc means data=sashelp.class stackodsoutput sum mean std nway;
 class sex;
 var height weight;
run;
proc print data=with_stackods noobs;
run;



/****Don't use nway*****/
ods output summary=with_stackods  (drop=_control_);
proc means data=sashelp.class stackodsoutput sum mean std ;
 class sex;
 var height weight;
run;
proc print data=with_stackods noobs;
run;

Re: proc means with stackodsoutput option

Karen_Horton — Thu, 09 Aug 2018 09:04:15 GMT

Hi,

From the SAS procedures website:

NWAY

specifies that the output data set contain only statistics for the observations with the highest _TYPE_ and _WAY_ values. When you specify class variables, NWAY corresponds to the combination of all class variables.

As you have a class variable and a NWAY statement, it views the overall group as a distinct group and will then also present in the output dataset.

Thanks,

Karen.

Re: proc means with stackodsoutput option

Ksharp — Thu, 09 Aug 2018 12:42:55 GMT

Or using the following instead.

 by sex;

But the dataset must be sorted before .

Re: proc means with stackodsoutput option

ballardw — Thu, 09 Aug 2018 15:37:36 GMT

TYPES and WAYS statements may help.

Consider:

ods output summary=with_stackods  (drop=_control_);
proc means data=sashelp.class stackodsoutput sum mean std ;
 class sex;
 var height weight;
 types sex ();
run;

The () on types specifyies the _type_=0 grand summary.