topic Re: Data not displaying in SAS Visual Analytics 7.3 Crosstab visualization for 2650 rows and 31 colu in SAS Visual Analytics

Data not displaying in SAS Visual Analytics 7.3 Crosstab visualization for 2650 rows and 31 columns

S_hanjagimath — Fri, 20 Sep 2019 05:22:31 GMT

Hi,

I created Crosstab visualization in SAS VA 7.3 with 2650 rows and 31 columns and getting the error message as "Too much data to Display".

How should I solve this problem. As per the documentation croostab can hold up to 40000 rows.

Any idea how should I resolve this problem

Re: Data not displaying in SAS Visual Analytics 7.3 Crosstab visualization for 2650 rows and 31 colu

Madelyn_SAS — Fri, 20 Sep 2019 13:30:18 GMT

You are likely running into a midtier limit on cardinality for crosstabs. According to the Visual Analytics administration documentation, the middle-tier maximum cardinality threshold for crosstabs is 50,000 unique values (not the maximum volume of data). Does the table include high-cardinality data items? You can sometimes work around this by changing the roles for some of your categories from rows to columns or vice versa.