47897 - Numbers might be formatted incorrectly when you export data to Microsoft Excel

Problem Note 47897: Numbers might be formatted incorrectly when you export data to Microsoft Excel

With certain regional settings, numeric columns that are included in SAS® Activity-Based Management OLAP cube data and are exported to Microsoft Excel might be formatted incorrectly. This incorrect formatting happens in the OLAP Analyzers in SAS Activity-Based Management 7.1.

To obtain a fix for this issue, contact SAS Technical Support.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Activity-Based Management	Microsoft Windows Server 2003 for x64	7.1	7.2	9.2 TS2M0	9.3 TS1M2
		Microsoft Windows Server 2008 for x64	7.1	7.2	9.2 TS2M0	9.3 TS1M2
		Microsoft Windows XP Professional	7.1	7.2	9.2 TS2M0	9.3 TS1M2
		Microsoft® Windows® for x64	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Microsoft Windows Server 2003 Datacenter Edition	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Microsoft Windows Server 2003 Enterprise Edition	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Microsoft Windows Server 2003 Standard Edition	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Microsoft Windows Server 2008	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows 7 Enterprise 32 bit	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows 7 Enterprise x64	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows 7 Home Premium 32 bit	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows 7 Home Premium x64	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows 7 Professional 32 bit	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows 7 Professional x64	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows 7 Ultimate 32 bit	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows 7 Ultimate x64	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows Vista	7.2	7.2	9.2 TS2M2	9.3 TS1M2
		Windows Vista for x64	7.2	7.2	9.2 TS2M2	9.3 TS1M2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

A fix for this issue for SAS Enterprise Guide 5.1 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/G35.html#47897

A fix for this issue for SAS Add-in for Microsoft Office 5.1 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/G36.html#47897

Type:	Problem Note
Priority:	medium

Date Modified:	2012-09-20 10:18:30
Date Created:	2012-09-17 10:34:49