topic Calculations on proctabulated tables in SAS Procedures

topic Calculations on proctabulated tables in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Calculations-on-proctabulated-tables/m-p/160053#M41734 <HTML><HEAD></HEAD><BODY><P>I have proc tabulated 2 tables A and B  and I want to  calculate proportions  on table C , can this be done easily on SAS.</P><P>Example below;</P><P></P><P>Table A</P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Tables</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">10</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Chairs</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">15</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Total</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">25</P></TD></TR></TBODY></TABLE><P></P><P>Table B</P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Blue Tables</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">5</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Blue Chairs</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">5</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Total</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">10</P></TD></TR></TBODY></TABLE><P></P><P>Table C ( proportion of B compared to A) i.e for tables (10-5)/10 *100</P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Tables</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">50 </P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Chairs</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P>66.66</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Total</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">60</P></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 06 Nov 2014 21:03:49 GMT menhtp 2014-11-06T21:03:49Z Calculations on proctabulated tables https://communities.sas.com/t5/SAS-Procedures/Calculations-on-proctabulated-tables/m-p/160053#M41734 <HTML><HEAD></HEAD><BODY><P>I have proc tabulated 2 tables A and B  and I want to  calculate proportions  on table C , can this be done easily on SAS.</P><P>Example below;</P><P></P><P>Table A</P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Tables</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">10</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Chairs</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">15</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Total</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">25</P></TD></TR></TBODY></TABLE><P></P><P>Table B</P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Blue Tables</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">5</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Blue Chairs</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">5</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Total</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">10</P></TD></TR></TBODY></TABLE><P></P><P>Table C ( proportion of B compared to A) i.e for tables (10-5)/10 *100</P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Tables</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">50 </P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Chairs</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P>66.66</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">Total</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="385"><P style="margin-bottom: .0001pt;">60</P></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 06 Nov 2014 21:03:49 GMT https://communities.sas.com/t5/SAS-Procedures/Calculations-on-proctabulated-tables/m-p/160053#M41734 menhtp 2014-11-06T21:03:49Z