topic Re: percent by row in SAS Visual Analytics

topic Re: percent by row in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/percent-by-row/m-p/226200#M2530 <P><A href="https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-get-crosstab-columns-monthly-to-total-100-instead-of-as-a/m-p/146368#U146368" target="_blank">https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-get-crosstab-columns-monthly-to-total-100-instead-of-as-a/m-p/146368#U146368</A></P><P>has answered my question.</P> Fri, 18 Sep 2015 07:24:04 GMT hir_7 2015-09-18T07:24:04Z percent by row https://communities.sas.com/t5/SAS-Visual-Analytics/percent-by-row/m-p/226168#M2527 <P>I need to convert below table into crosstab. Month would be rows, range would be columns and measure has to be % of balance by row (per month).</P><P> </P><P>I've tried "Percent of Total", but it calculates % of overall total but not % of row total.</P><P> </P><P>Any help is greatly appreciated.</P><P> </P><TABLE><TBODY><TR><TD>month</TD><TD>range</TD><TD>Count</TD><TD> Balance </TD></TR><TR><TD>Jan-15</TD><TD><30</TD><TD>18</TD><TD> $              996,958</TD></TR><TR><TD>Jan-15</TD><TD><60</TD><TD>83</TD><TD> $        324,331</TD></TR><TR><TD>Jan-15</TD><TD><80</TD><TD>153</TD><TD> $        271,065</TD></TR><TR><TD>Jan-15</TD><TD><90</TD><TD>91</TD><TD> $        2,761,917</TD></TR><TR><TD>Jan-15</TD><TD><100</TD><TD>58</TD><TD> $        9,227,751</TD></TR><TR><TD>Jan-15</TD><TD>100+</TD><TD>3</TD><TD> $              995,563</TD></TR></TBODY></TABLE> Fri, 18 Sep 2015 01:39:33 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/percent-by-row/m-p/226168#M2527 hir_7 2015-09-18T01:39:33Z Re: percent by row https://communities.sas.com/t5/SAS-Visual-Analytics/percent-by-row/m-p/226200#M2530 <P><A href="https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-get-crosstab-columns-monthly-to-total-100-instead-of-as-a/m-p/146368#U146368" target="_blank">https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-get-crosstab-columns-monthly-to-total-100-instead-of-as-a/m-p/146368#U146368</A></P><P>has answered my question.</P> Fri, 18 Sep 2015 07:24:04 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/percent-by-row/m-p/226200#M2530 hir_7 2015-09-18T07:24:04Z