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

Proc means calculate percent from total

shadowgun1102 — Fri, 07 Jun 2019 08:38:27 GMT

Hello everyone

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

Thanks!

Re: Proc means calculate percent from total

andreas_lds — Fri, 07 Jun 2019 08:54:46 GMT

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=home.htm

proc tabulate can do this :

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

   table Sex, Age*pctsum;
run;

Re: Proc means calculate percent from total

ballardw — Fri, 07 Jun 2019 14:58:14 GMT

@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%.

Re: Proc means calculate percent from total

Ksharp — Sat, 08 Jun 2019 15:42:50 GMT

proc sql;
select name,weight,weight/(select sum(weight) from sashelp.class) as percent format=percent8.2
 from sashelp.class;
quit;