topic Re: SAS VA report exporting as excel file limitation in SAS Visual Analytics

SAS VA report exporting as excel file limitation

pgadde — Thu, 11 Jul 2019 17:38:31 GMT

Is there a limit in the number of rows that can be extracted from SAS VA reports. I developed a report which using List table to display the data.The total number of records in the table are 255k which is imported into SAS VA as LASR table. But when I try to export the data into Excel file from the report using detailed, it is only exporting 50k rows!

Re: SAS VA report exporting as excel file limitation

Madelyn_SAS — Thu, 11 Jul 2019 18:05:28 GMT

This issue should have been addressed in a hot fix

http://support.sas.com/kb/61/087.html

What hot fix level do you have?

Re: SAS VA report exporting as excel file limitation

pgadde — Thu, 11 Jul 2019 19:07:13 GMT

How can i check the hot fix level?

Re: SAS VA report exporting as excel file limitation

Madelyn_SAS — Thu, 11 Jul 2019 19:13:17 GMT

You can get this from Visual Analytics Designer. From the Help menu, select About SAS Visual Analytics Designer. The dialog box should have the hot fix level. If you see only the version number (e.g., 7.4), then you don't have any hot fixes.

Re: SAS VA report exporting as excel file limitation

pgadde — Thu, 11 Jul 2019 19:22:48 GMT

Hi, I don't see any hot fixes applied.

Re: SAS VA report exporting as excel file limitation

pgadde — Fri, 12 Jul 2019 17:19:44 GMT

We will look into applying the hotfix. Thanks for the help.