topic Visual Analytics Percentage Frequency Count in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-Percentage-Frequency-Count/m-p/171805#M1052 <HTML><HEAD></HEAD><BODY><P class="p1">Hi Everyone,</P><P class="p2"></P><P class="p1">I am tryng to implement the cross table with frequency counts on SAS Visual Analytics(ver. 9.4).</P><P class="p2"></P><P class="p1">The source table has field R and field C, both of them are category values. The cross table should show the frequency of each value C in percentage for each R value<SPAN style="font-size: 10pt; line-height: 1.5em;">.</SPAN></P><P class="p2">The example table&nbsp; is below.</P><P class="p1">e.g.</P><P class="p2"></P><P class="p1">&nbsp; C val\R val&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R3&nbsp; </P><P class="p1">128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.1%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.2%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.4%&nbsp;&nbsp;&nbsp; </P><P class="p1">256&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.1%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.4%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.4%</P><P class="p1">512&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.2%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.5%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.5%</P><P class="p1"><SPAN style="font-size: 10pt; line-height: 1.5em;">1024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.3%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.6%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.5%</SPAN></P><P class="p1"><SPAN style="font-size: 10pt; line-height: 1.5em;">...</SPAN></P><P class="p1">Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P class="p2"></P><P class="p2">The standard Frequency Percent measure seems to calculate the percentage from all values(not broken down by "R" values), </P><P class="p1">I am new to SAS and will appreciate any suggestion or comment.</P></BODY></HTML> Fri, 14 Nov 2014 11:40:26 GMT alse 2014-11-14T11:40:26Z Visual Analytics Percentage Frequency Count https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-Percentage-Frequency-Count/m-p/171805#M1052 <HTML><HEAD></HEAD><BODY><P class="p1">Hi Everyone,</P><P class="p2"></P><P class="p1">I am tryng to implement the cross table with frequency counts on SAS Visual Analytics(ver. 9.4).</P><P class="p2"></P><P class="p1">The source table has field R and field C, both of them are category values. The cross table should show the frequency of each value C in percentage for each R value<SPAN style="font-size: 10pt; line-height: 1.5em;">.</SPAN></P><P class="p2">The example table&nbsp; is below.</P><P class="p1">e.g.</P><P class="p2"></P><P class="p1">&nbsp; C val\R val&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R3&nbsp; </P><P class="p1">128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.1%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.2%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.4%&nbsp;&nbsp;&nbsp; </P><P class="p1">256&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.1%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.4%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.4%</P><P class="p1">512&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.2%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.5%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.5%</P><P class="p1"><SPAN style="font-size: 10pt; line-height: 1.5em;">1024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.3%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.6%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.5%</SPAN></P><P class="p1"><SPAN style="font-size: 10pt; line-height: 1.5em;">...</SPAN></P><P class="p1">Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P class="p2"></P><P class="p2">The standard Frequency Percent measure seems to calculate the percentage from all values(not broken down by "R" values), </P><P class="p1">I am new to SAS and will appreciate any suggestion or comment.</P></BODY></HTML> Fri, 14 Nov 2014 11:40:26 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-Percentage-Frequency-Count/m-p/171805#M1052 alse 2014-11-14T11:40:26Z Re: Visual Analytics Percentage Frequency Count https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-Percentage-Frequency-Count/m-p/171806#M1053 <HTML><HEAD></HEAD><BODY><P>I just posted the same issue today. This is a major issue and needs to be addressed!!!</P></BODY></HTML> Fri, 30 Jan 2015 18:18:34 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-Percentage-Frequency-Count/m-p/171806#M1053 howardn 2015-01-30T18:18:34Z Re: Visual Analytics Percentage Frequency Count https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-Percentage-Frequency-Count/m-p/171807#M1054 <HTML><HEAD></HEAD><BODY><P>See Rick Skyll's answer to "<A _jive_internal="true" href="https://communities.sas.com/thread/65044">How to get crosstab columns (monthly) to total 100%, instead of as a sub-percentage of the entire (year) measure?</A>" posted on Friday.</P></BODY></HTML> Mon, 02 Feb 2015 19:36:13 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-Percentage-Frequency-Count/m-p/171807#M1054 howardn 2015-02-02T19:36:13Z