BookmarkSubscribeRSS Feed
shadowgun1102
Calcite | Level 5

Hello everyone

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

Thanks!

3 REPLIES 3
andreas_lds
Jade | Level 19

Afaik not, but i am to lazy to look in the docs.

 

The docs can be found at https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=pgmsashome&docsetTarget=h...

 

proc tabulate can do this :

proc tabulate data=sashelp.class;
   class Sex;
   var Age;

   table Sex, Age*pctsum;
run;
ballardw
Super User

@shadowgun1102 wrote:

Hello everyone

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

Thanks!


The exception to @andreas_lds's response is a variable that is coded with only 1 and 0 values. The mean would be the "percent of 1's" for the records with values expressed in  decimal form: .456 as the mean would be equivalent to 45.6%.

Ksharp
Super User
proc sql;
select name,weight,weight/(select sum(weight) from sashelp.class) as percent format=percent8.2
 from sashelp.class;
quit;
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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1523 views
  • 0 likes
  • 4 in conversation