Data items are sorted in the wrong order in Microsoft Excel when exporting crosstab data from SAS® Visual Analytics Viewer 7.5x


Data items are sorted in the wrong order in Microsoft Excel when exporting crosstab data from SAS® Visual Analytics 7.5x. This problem can occur when you turn on subtotals with placement set to AFTER.

For example, the following screenshot contains a crosstab in SAS Visual Analytics Viewer 7.5x:

Crosstab in SAS visual analytics viewer

When you export the data from the crosstab in Microsoft Excel, the data is sorted in the wrong order, as shown in the following image:

Crosstab data is sorted in the wrong order

To work around the issue, complete the following steps:

  1. Export from the Designer or Edit mode.
  2. Click the Options menu on the right pane.
  3. Change the Subtotals Placement setting to BEFORE.

Select Before for the Subtotals Placement setting.

The output should look similar to the following:

Crosstab data columns are sorted in the right order

Note: This issue is fixed in SAS® Visual Analytics Viewer 8.5.2 and later.