When you export SAS Visual Analytics crosstab measure values to Excel, one of two issues might occur:

• The unformatted format values for the category are exported instead of a measure's actual value.
• Values for other measures might appear under the wrong column label.

This issue occurs when the following are true:

• You use user-defined formats on category variables.

• You set the Sort Options property in the category with user-defined formats to Unformatted.

• You use a calculated item that is defined with aggregates measures in the table

Example

In this example, a user-defined format is defined in the Sex category:

1='Male'

2='Female'

3='Unknown'

In the Sex category, Sort options is set to Unformatted.

Calculated Item 2 is defined as an aggregated measure. In this scenario, two issues occur:

• The unformatted values for the Sex category are exported instead of the Calculated Item 2 values. 
• The values for Calculated Item 2 are displayed under the incorrect column name (Frequency Percent). 

You can see the issue here:

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

Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at