Problem Note 67042: Labels for the Total and Subtotal columns might be missing when you export cross tables to CSV and TSV files in SAS® Visual Analytics
When you export cross tables to CSV and TSV files in SAS Visual Analytics, the labels for the Total and Subtotal columns might be missing.
For example, you might encounter this issue if you complete steps similar to the following:
- Create a new report that contains a cross table with a data item for a Columns role and another one for a Rows role.
- Select the Totals (Rows and Columns) and the Subtotals (Rows and Columns) option in the Options pane to display the totals for rows.

- Export the cross table. The label for the Total and Subtotal columns might be missing in the CSV and TSV files.
The following image shows the output file when you export to a CSV file. As you can see, labels for Total and Subtotal columns are missing.

As a workaround, export cross tables to an XLSX file instead of to CSV and TSV files.
Operating System and Release Information
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.51 | | 9.4 TS1M7 | |
| Linux for x64 | 7.51 | | 9.4 TS1M7 | |
*
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.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-12-07 09:46:26 |
| Date Created: | 2020-12-04 05:01:15 |