topic In PROC TABULATE, possible to compute up to 100% for each group rather than entire row or column? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/In-PROC-TABULATE-possible-to-compute-up-to-100-for-each-group/m-p/758464#M80848 <P>For example when looking at the 2 tables below, we know rowpctn/rowpctsum tend to show % breakdown for entire row using a + b + c +d as denominator.</P> <TABLE width="857"> <TBODY> <TR> <TD width="62">&nbsp;</TD> <TD colspan="3" width="326">Class 1</TD> <TD colspan="3" width="326">Class 2</TD> <TD width="143">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>Column 1</TD> <TD>Column 2</TD> <TD>Class 1 row total</TD> <TD>Column 3</TD> <TD>Column 4</TD> <TD>Class 2 row total</TD> <TD>Grand row total</TD> </TR> <TR> <TD>Row 1</TD> <TD>a</TD> <TD>b</TD> <TD>a + b</TD> <TD>c</TD> <TD>d</TD> <TD>c + d</TD> <TD>a + b + c +d</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <TABLE width="1237"> <TBODY> <TR> <TD width="62">&nbsp;</TD> <TD colspan="3" width="518">Class 1</TD> <TD colspan="3" width="514">Class 2</TD> <TD width="143">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>Column 1</TD> <TD>Column 2</TD> <TD>Class 1 row total</TD> <TD>Column 3</TD> <TD>Column 4</TD> <TD>Class 2 row total</TD> <TD>Grand row total</TD> </TR> <TR> <TD>Row 1</TD> <TD>a / (a + b + c +d)</TD> <TD>b / (a + b + c +d)</TD> <TD>(a + b) / (a + b + c +d)</TD> <TD>c / (a + b + c +d)</TD> <TD>d / (a + b + c +d)</TD> <TD>(c + d) / (a + b + c +d)</TD> <TD>100%</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>But is there a way to tally up to 100% for each section like this table below?</P> <TABLE width="714"> <TBODY> <TR> <TD width="62">&nbsp;</TD> <TD colspan="3" width="326">Class 1</TD> <TD colspan="3" width="326">Class 2</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>Column 1</TD> <TD>Column 2</TD> <TD>Class 1 row total</TD> <TD>Column 3</TD> <TD>Column 4</TD> <TD>Class 2 row total</TD> </TR> <TR> <TD>Row 1</TD> <TD>a / (a + b)</TD> <TD>b / (a + b)</TD> <TD>100%</TD> <TD>c / (c + d)</TD> <TD>d / (c + d)</TD> <TD>100%</TD> </TR> </TBODY> </TABLE> Fri, 30 Jul 2021 18:39:53 GMT BigPete 2021-07-30T18:39:53Z In PROC TABULATE, possible to compute up to 100% for each group rather than entire row or column? https://communities.sas.com/t5/SAS-Procedures/In-PROC-TABULATE-possible-to-compute-up-to-100-for-each-group/m-p/758464#M80848 <P>For example when looking at the 2 tables below, we know rowpctn/rowpctsum tend to show % breakdown for entire row using a + b + c +d as denominator.</P> <TABLE width="857"> <TBODY> <TR> <TD width="62">&nbsp;</TD> <TD colspan="3" width="326">Class 1</TD> <TD colspan="3" width="326">Class 2</TD> <TD width="143">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>Column 1</TD> <TD>Column 2</TD> <TD>Class 1 row total</TD> <TD>Column 3</TD> <TD>Column 4</TD> <TD>Class 2 row total</TD> <TD>Grand row total</TD> </TR> <TR> <TD>Row 1</TD> <TD>a</TD> <TD>b</TD> <TD>a + b</TD> <TD>c</TD> <TD>d</TD> <TD>c + d</TD> <TD>a + b + c +d</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <TABLE width="1237"> <TBODY> <TR> <TD width="62">&nbsp;</TD> <TD colspan="3" width="518">Class 1</TD> <TD colspan="3" width="514">Class 2</TD> <TD width="143">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>Column 1</TD> <TD>Column 2</TD> <TD>Class 1 row total</TD> <TD>Column 3</TD> <TD>Column 4</TD> <TD>Class 2 row total</TD> <TD>Grand row total</TD> </TR> <TR> <TD>Row 1</TD> <TD>a / (a + b + c +d)</TD> <TD>b / (a + b + c +d)</TD> <TD>(a + b) / (a + b + c +d)</TD> <TD>c / (a + b + c +d)</TD> <TD>d / (a + b + c +d)</TD> <TD>(c + d) / (a + b + c +d)</TD> <TD>100%</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>But is there a way to tally up to 100% for each section like this table below?</P> <TABLE width="714"> <TBODY> <TR> <TD width="62">&nbsp;</TD> <TD colspan="3" width="326">Class 1</TD> <TD colspan="3" width="326">Class 2</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>Column 1</TD> <TD>Column 2</TD> <TD>Class 1 row total</TD> <TD>Column 3</TD> <TD>Column 4</TD> <TD>Class 2 row total</TD> </TR> <TR> <TD>Row 1</TD> <TD>a / (a + b)</TD> <TD>b / (a + b)</TD> <TD>100%</TD> <TD>c / (c + d)</TD> <TD>d / (c + d)</TD> <TD>100%</TD> </TR> </TBODY> </TABLE> Fri, 30 Jul 2021 18:39:53 GMT https://communities.sas.com/t5/SAS-Procedures/In-PROC-TABULATE-possible-to-compute-up-to-100-for-each-group/m-p/758464#M80848 BigPete 2021-07-30T18:39:53Z Re: In PROC TABULATE, possible to compute up to 100% for each group rather than entire row or column https://communities.sas.com/t5/SAS-Procedures/In-PROC-TABULATE-possible-to-compute-up-to-100-for-each-group/m-p/758480#M80849 Yes, use the syntax format of PCTN&lt;CLASS&gt;<BR /><BR />See examples of column/row stats here:<BR /><A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1m5z9bzbggfson1wgywh01h8zlq.htm" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1m5z9bzbggfson1wgywh01h8zlq.htm</A> Fri, 30 Jul 2021 18:57:44 GMT https://communities.sas.com/t5/SAS-Procedures/In-PROC-TABULATE-possible-to-compute-up-to-100-for-each-group/m-p/758480#M80849 Reeza 2021-07-30T18:57:44Z Re: In PROC TABULATE, possible to compute up to 100% for each group rather than entire row or column https://communities.sas.com/t5/SAS-Procedures/In-PROC-TABULATE-possible-to-compute-up-to-100-for-each-group/m-p/758494#M80850 <P>Thank you</P> Fri, 30 Jul 2021 19:43:23 GMT https://communities.sas.com/t5/SAS-Procedures/In-PROC-TABULATE-possible-to-compute-up-to-100-for-each-group/m-p/758494#M80850 BigPete 2021-07-30T19:43:23Z