BookmarkSubscribeRSS Feed
Calcite | Level 5

Hello everyone

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


Pyrite | Level 9

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;
Super User

@kullboys wrote:

Hello everyone

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


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.


Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 3 in conversation