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

proc means calculate percent from total

Ronein — Mon, 13 Aug 2018 05:50:02 GMT

Hello

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

Re: proc means calculate percent from total

ChrisNZ — Mon, 13 Aug 2018 10:34:17 GMT

You can, but it's a 2-step process.

Don't let that deter you though. It is very powerful and you can derive many percentages in one go.

Something like:

proc means;

class A B C D E F;

types A* (B*C B*D B*E B*F) /* whatever crossings you need */

(B*C B*D B*E B*F);

output out=SUM n= /* whatever stats you need, or just counts*/ ;

run;

data PCT;

merge SUM( rename=(_FREQ_=TOTAL) where=( missing(A)) )

SUM( rename=(_FREQ_=COUNT) where=(^missing(A)) ) ;

by B C D E F;

PCT= COUNT / TOTAL;

drop A;

run;

Adapt to your needs. Untested code written from afk, but the principle is sound.

Re: proc means calculate percent from total

Reeza — Mon, 13 Aug 2018 15:25:37 GMT

It's possible but I'd probably recommend PROC TABULATE instead, which can likely do it in one step instead. Assuming you're not actually asking if its possible but how to do it, I would refer to the following:

proc tabulate data=sashelp.cars format=8.2;
 class origin type;
 table type all, (origin all)*(n*f=8. reppctn) / rts=10;
run;

More details are available here:

https://support.sas.com/resources/papers/proceedings13/134-2013.pdf

@Ronein wrote:

Hello

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