SAS Visual Analytics missing rows

[Dritan007]

Hello.

I have a table with 120 columns and 22k rows loaded into memory and promoted.
I add the columns 1 by 1 at a list table but when I added the first 4 columns (category type) the total rows reduced to 21k.
I continue adding more columns to the table and the total rows from the report keeps decreasing. I end up with 1700 rows.

Notice that I have selected "Detail Data" in the options to specify NOT to aggregate on any column.
It does not show any error though, while building the table.

Some columns have missing values too, but not all the columns at the same time. (At least 1 column is non-missing for every row).

Thank you for any help or suggestion.

[Madelyn_SAS]

Which version of Visual Analytics are you using? 

[Dritan007]

Version 8.5.1

[acordes]

Visual Analytics is not designed for showing big tables. 

Its main purpose is to aggregate data. 

A table size limit kicks in and reduces the rows/columns combo accordingly.  

Even knowing this and designing the reports accordingly I have the need for exporting medium sized tables now and then. To circumvent the size limit I apply filters. 

Imagine a table with 30k rows and 40 columns, probably I have to subset the table by year or quarter (imagine a date variables for sales figures) in order to fiit all rows into the display prior to its export as excel.

BUT if this bothers you all the time you likely don't use Visual Analytics in the way it was intended for. 

[Madelyn_SAS · Accepted solution]

The first thing to try is changing the Override system data limit on the Options tab for the object. If that does not work, then a midtier limit is being exceeded. Typically, we do not recommend changing those since they are in place for performance reasons. 

For more information, see https://support.sas.com/kb/62/148.html 

[Dritan007]

Thank you very much.
defaultMaxCellsProduced had reached its limit.