topic Re: SAS Visual Analytics missing rows in SAS Visual Analytics

SAS Visual Analytics missing rows

Dritan007 — Thu, 17 Feb 2022 16:32:23 GMT

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.

Re: SAS Visual Analytics missing rows

Madelyn_SAS — Thu, 17 Feb 2022 17:15:57 GMT

Which version of Visual Analytics are you using?

Re: SAS Visual Analytics missing rows

Dritan007 — Fri, 18 Feb 2022 08:52:46 GMT

Version 8.5.1

Re: SAS Visual Analytics missing rows

acordes — Fri, 18 Feb 2022 09:39:26 GMT

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.

Re: SAS Visual Analytics missing rows

Madelyn_SAS — Fri, 18 Feb 2022 18:51:42 GMT

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

Re: SAS Visual Analytics missing rows

Dritan007 — Mon, 21 Feb 2022 08:33:43 GMT

Thank you very much.
defaultMaxCellsProduced had reached its limit.