SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 66557: SAS® Visual Analytics fails to export data from crosstabs and list tables that include totals

DetailsHotfixAboutRate It

In some circumstances, SAS Visual Analytics does not export data from crosstabs and list tables. When you click OK in the Export Data dialog box, no file is created and there are no messages to indicate that a problem has occurred.

This problem occurs when total values are placed at the top of the table, and you do not select the first data item listed in the Export Data dialog box.

There are three workarounds for this issue, depending on your preferences: 

  • If you want to exclude the first data item from the exported data, you can move the totals to the bottom of the table before exporting.
  • If you want to keep the totals at the top of the table, you can include the first data item in the exported data.
  • If you want to exclude the first data item from the exported data and the total values are not required, you can remove the totals from the table before exporting. 

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



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual Analytics (on SAS Viya)Linux for x648.32020.1Viya
Microsoft® Windows® for x648.32020.1Viya
* 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.