Hello everyone
Is it possible to calculate percent from total in proc means ?
Thanks!
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;
@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%.
proc sql;
select name,weight,weight/(select sum(weight) from sashelp.class) as percent format=percent8.2
from sashelp.class;
quit;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.