When you export a list table to Excel by using the option Export ► Data, SAS Visual Analytics might not use the browser locale. This issue occurs if the list table contains a data item with a date or a currency format applied.

For example, you might encounter this issue when you complete steps similar to the following:

1. Create a calculated item with the format DATEN9. Here is an example: 30 August 2021.
2. Add the calculated item into a list table.
3. Set your browser’s language to German (for example) and select Browser locale in the SAS Visual Analytics Settings under Region and Language, as shown below:

4. View the report in SAS Visual Analytics. The list table displays the calculated item with the correct date format in the German language: DD.MM.YYYY (30.08.2021).

5. Export the list table to Excel. The date data item might be displayed in English instead of in German. The following image shows the problem in the Excel workbook. The calculated item is displayed with a different format (MM/DD/YYYY) than the one that is displayed in SAS Visual Analytics (DD.MM.YYYY)

To work around this problem, export to a CSV files rather than to XLSX files.

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

A fix for this issue for SAS Visual Analytics 7.51 is available at:

A fix for this issue for SAS Visual Analytics 7.5 is available at: