SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 63500: SAS® Visual Analytics and SAS® Report Viewer export a different number of rows to Microsoft Excel

DetailsHotfixAboutRate It

When exporting data from SAS Visual Analytics, you can specify how many rows to export. If you do not specify the number of rows, the number of rows exported to Excel might vary between SAS Visual Analytics and SAS Report Viewer. 

The difference is that when the request for data is submitted and the number of rows is not explicitly defined, SAS Visual Analytics does not specify a maximum. However, SAS Report Viewer does specify a maximum based on the number of rows that are being displayed in the web client. If there is so much data that the web client has limited the number of rows displayed, then the export action from SAS Visual Analytics exports as much as the server allows, which might be more rows than are displayed in the web client.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

The hot fix changes the SAS Report Viewer behavior to match SAS Visual Analytics.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Report ViewerLinux for x648.38.4ViyaViya
Microsoft® Windows® for x648.38.4ViyaViya
SAS SystemSAS Visual AnalyticsMicrosoft® Windows® for x648.38.4ViyaViya
Linux for x648.38.4ViyaViya
Cloud Foundry8.38.4ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.