topic Re: Get summary statistics by class level and overall in New SAS User

Get summary statistics by class level and overall

cbt2119 — Mon, 11 Mar 2019 18:01:23 GMT

Hi SAS Community,

I have searched the knowledge base and Google, but can't see to find the answer to what seems to be a simple question. Is it possible to run a single proc means/summary or proc tabulate statement and get the class level summary statistics for a variable as well as the overall summary statistics? I have to run two separate procedures, to get both - one with the class statement and one omitting the class statement. I don't want to have to output it to a data set either. Does anyone know a more efficient way to do this? Example of the longhand code I run below.

Thanks,

Cara

proc means data=workdata; class binaryvar ; var continuousvar; run;
proc means data=workdata; var continuousvar; run;

Re: Get summary statistics by class level and overall

Astounding — Mon, 11 Mar 2019 18:09:13 GMT

If you take the top PROC MEANS, and add an OUTPUT statement (with all the necessary details), the output data set will contain just what you are asking for.

Re: Get summary statistics by class level and overall

PaigeMiller — Mon, 11 Mar 2019 19:09:19 GMT

proc summary data=workdata;
    class binaryvar;
    var continuousvar;
    output out=_stats_ mean=continuousvar_mean;
run;

Look up the documentation for PROC SUMMARY, please see the NWAY option, as well as the TYPES command and the WAYS command in PROC SUMMARY, these give you complete control over what combinations of CLASS variables are to be included in the output.

Re: Get summary statistics by class level and overall

cbt2119 — Mon, 11 Mar 2019 20:07:29 GMT

Is there a way to do it without using the output statement? Like is there an option in the class statement that also computes the overall statistics, like the totals rows and columns in proc freq?

Re: Get summary statistics by class level and overall

PaigeMiller — Mon, 11 Mar 2019 20:16:48 GMT

@cbt2119 wrote:

Is there a way to do it without using the output statement?

Yes, use PROC MEANS instead of PROC SUMMARY, and the WAYS or TYPES command. But without the OUTPUT statement, you get output to HTML or to the LISTING or some other print destination. With the OUTPUT statement, you get a data set.

... is there an option in the class statement that also computes the overall statistics, like the totals rows and columns in proc freq?

Yes, the WAYS or TYPES command will force the overall statistics to be printed out.

Re: Get summary statistics by class level and overall

Tom — Mon, 11 Mar 2019 20:23:31 GMT

proc means data=sashelp.class;
  class sex;
  var height;
  ways 0 1;
run;

Re: Get summary statistics by class level and overall

cbt2119 — Mon, 11 Mar 2019 20:25:58 GMT

Thanks, this works well too!