Visual Analytics Percentage Frequency Count

[alse]

Hi Everyone,

I am tryng to implement the cross table with frequency counts on SAS Visual Analytics(ver. 9.4).

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.

The example table  is below.

e.g.

  C val\R val      R1          R2            R3 

128                  1.1%        1.2%       1.4%   

256                  1.1%        1.4%       1.4%

512                  1.2%        1.5%       1.5%

1024                1.3%        1.6%       1.5%

...

Total                100%       100%      100%

The standard Frequency Percent measure seems to calculate the percentage from all values(not broken down by "R" values),

I am new to SAS and will appreciate any suggestion or comment.

[howardn]

I just posted the same issue today. This is a major issue and needs to be addressed!!!

[howardn]

See Rick Skyll's answer to "How to get crosstab columns (monthly) to total 100%, instead of as a sub-percentage of the entire (y..." posted on Friday.