Problem Note 65688: Data items are sorted in an unexpected order in Microsoft Excel when exporting crosstab data from SAS® Report Viewer
 |  |  |  |  |
Data items are sorted in an unexpected order in Microsoft Excel when exporting crosstab data from SAS Report Viewer. This problem can occur when your crosstab contains a calculated item and an aggregated measure in the Measures role, as shown in the following display:
The following display shows the crosstab. The order of the data items is as follows: Agg data item, Weight, Frequency, and Calculated item.
When you export data from the crosstab in SAS® Visual Analytics, the order of the data items reflects the order of the report object.
When you export data from the crosstab in SAS Report Viewer, the order of the data items does not reflect the order of the report object. As shown in the following display, the aggregated measure is the last column in the table.
This problem occurs for both new and promoted reports.
This issue does not occur beginning with release 8.4, which integrated SAS Report Viewer features into the SAS Visual Analytics user interface.
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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics (on SAS Viya) | Cloud Foundry | 8.3.1 | 8.4 | Viya | Viya |
| Linux for x64 | 8.3.1 | 8.4 | Viya | Viya | ||
| Microsoft® Windows® for x64 | 8.3.1 | 8.4 | Viya | Viya | ||
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.5 | 9.4 TS1M6 | ||
| Linux for x64 | 7.5 | 9.4 TS1M6 | ||||
Viya on Windows: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesWinViya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesA fix for this issue for SAS Visual Analytics 7.51 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9T.html#65688| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-04-17 08:47:20 |
| Date Created: | 2020-03-13 09:11:50 |