topic Re: Percentage calculation in PROC TABULATE in SAS Procedures

Percentage calculation in PROC TABULATE

Sathish_jammy — Mon, 19 Aug 2019 07:58:59 GMT

Dear Experts,

I used Proc tabulate procedure to solve the tally information of the given (sample dataset) table.

But I required a tally of the Percentage columns as 100%. For more details kindly go through the below information.

data aaa;
input ID age$ sex$ Emp$;
cards;
1 18-25 M Govt
2 50-60 F Pvt
6 26-35 F Govt
8 18-25 M Pvt
4 26-35 F Govt
5 36-45 M Govt
9 46-55 M Pvt
3 18-25 M Govt
0 36-45 M Govt
;
proc tabulate data = aaa;
class age sex Emp;
tables age all,Emp*(sex=' ' *(n*f=8. reppctn='%')) all='Total'*(n*f=8. reppctn='%')/rts=10;
run;

If you run the above code. It results N and % of 9 observations as Gender and Employment wise.

But I require a % column to calculate its value as 100% of its gender and employment like the Image given below.

Kindly suggest the code which results in an image.

If you require any clarification. I will be glad to help.

Thanks in advance!

Re: Percentage calculation in PROC TABULATE

Shmuel — Mon, 19 Aug 2019 08:16:31 GMT

You have used in your code REPPCT which is percentage per report.

You can use ROWPCTN to calculate row percentage or use PCTSUM to calculate column percentage.

Re: Percentage calculation in PROC TABULATE

Cynthia_sas — Mon, 19 Aug 2019 14:16:26 GMT

Hi:
For purposes of completeness:
PCTN PCTSUM
ROWPCTN ROWPCTSUM
COLPCTN COLPCTSUM
REPPCTN REPPCTSUM
PAGEPCTN PAGEPCTSUM

are all the percent statistics. Using one of these depends on whether you want the percent of the count (N) or the percent of a numeric variable (PCTSUM). Look in the TABULATE documentation and note that TABULATE does an automatic multiply by 100, so you need to use a PICTURE format to get the % sign into the TABULATE output.

Cynthia