topic Re: Proc means calculate percent from total in SAS Programming

Proc means calculate percent from total

kullboys — Thu, 16 Aug 2018 08:29:42 GMT

Hello everyone

Is it possible to calculate percent from total in proc means >?

Thanks.

Re: Proc means calculate percent from total

cau83 — Thu, 16 Aug 2018 11:45:31 GMT

You would need to do it in a couple steps, eg:

proc means data=yourdata;
  by group;
  var your-var;
  output out=group sum=total;

proc means data=yourdata;
  by group subgroup;
  var your-var;
  output out=subgroup sum=subtotal;

data pct_of_total;
  merge group subgroup;
  by group;
  pct_of_total=subtotal/total;
run;

Re: Proc means calculate percent from total

ballardw — Thu, 16 Aug 2018 14:37:02 GMT

@kullboys wrote:

Hello everyone

Is it possible to calculate percent from total in proc means >?

Thanks.

Other than not very clearly explaining what "from total" might imply (I can think of several interpretations), not in proc means. The documentation is pretty clear about what statistics proc means will calculate and percentages are not included.

Proc means can create an output data set that likely has the sums and/or n's that you need but will take other steps.

Proc tabulate and report both will create percentages but of specific forms and without actual example data and the desired result I can't go any further than that.