Problem Note 70680: Exporting data from the SAS® Visual Analytics Report Viewer does not export all of the data items if some of the items contain duplicated names
 |  |  |  |  |
In SAS Visual Analytics, you can have a report that is based on a data source that contains columns with the same labels but different names.
If you create a list table and you use data items with the same names as roles, you can display the items on the list table. For example, the list table could contain col1, col1, col2, and col2.
If you select the Export data option from the list table from SAS® Visual Analytics Designer, all columns (col1, col1, col2, and col2) and their values are correctly exported to the external file.
However, if you export the same list table from the SAS Visual Analytics Report Viewer, not all of the columns are exported to the external file. For example, only col1 and col2 and the related values might be displayed in the external files. Duplicated column names are not exported.
To circumvent this issue, do either of the following:
- Export the data from SAS Visual Analytics Designer.
- Avoid using the same labels for different column names.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics (on SAS 9.x) | Linux for x64 | 7.51 | 8.5 | 9.4 TS1M8 | Viya |
| Microsoft® Windows® for x64 | 7.51 | 8.5 | 9.4 TS1M8 | Viya | ||