Usage Note 55909: How SAS® Visual Analytics exports export crosstab data to Microsoft Excel
 |  |  |  |
SAS® Visual Analytics Designer, SAS® Visual Analytics Viewer, and SAS® Visual Analytics on SAS® Viya® 2020.1.5 and earlier export crosstab data into a list table in Microsoft Excel.
For example, the following display shows a crosstab in SAS Visual Analytics Viewer 7.51:
When you export the data in this table, the results appear in a list table, as shown in the following display:
To preserve crosstab format, you can open the report directly using the SAS® Add-In for Microsoft Office.
Beginning with SAS Visual Analytics on SAS Viya 2021.1, the crosstab format is preserved, as shown in the following display:
For more information, see Exporting Data, Microsoft Excel Workbooks, and Images from Objects.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.1 | 9.4 TS1M2 | ||
| Linux for x64 | 7.1 | 9.4 TS1M2 | ||||
| SAS System | SAS Visual Analytics (on SAS Viya) | Linux for x64 | 8.2 | Viya | ||
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2022-12-09 14:22:00 |
| Date Created: | 2015-06-01 15:27:06 |