Problem Note 67187: Custom sort orders are not correctly exported to Microsoft Excel from SAS® Visual Analytics Viewer
 |  |  |  |  |
Custom sort orders are not correctly exported to Excel from SAS Visual Analytics Viewer under the following conditions:
- You apply a custom sort order to a category (X).
- You use the category (X) in a hierarchy.
- You use the hierarchy in a crosstab object.
- You export 'Formatted Data'.
Here is an example that illustrates this issue.
- A custom sort order on Make (Chevrolet, Ford, Chrysler, Dodge, Buick) is applied. It is displayed correctly in SAS Visual Analytics Viewer:
- The data is exported to Excel. The custom sort order is not applied correctly:
To work around the issue, export from the Designer/Edit mode. Using this method correctly exports the data. The issue appears only when exporting from Viewer.
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 | Microsoft® Windows® for x64 | 7.5 | 9.4 TS1M6 | ||
| Linux for x64 | 7.5 | 9.4 TS1M6 | ||||
A fix for this issue for SAS Visual Analytics 7.51 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9T.html#67187A fix for this issue for SAS Visual Analytics 7.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F9L.html#67187| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-07-21 08:59:47 |
| Date Created: | 2021-01-06 09:54:46 |