SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Activity-Based ManagementMicrosoft Windows Server 2003 for x647.17.29.2 TS2M09.3 TS1M2
Microsoft Windows Server 2008 for x647.17.29.2 TS2M09.3 TS1M2
Microsoft Windows XP Professional7.17.29.2 TS2M09.3 TS1M2
Microsoft® Windows® for x647.27.29.2 TS2M29.3 TS1M2
Microsoft Windows Server 2003 Datacenter Edition7.27.29.2 TS2M29.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition7.27.29.2 TS2M29.3 TS1M2
Microsoft Windows Server 2003 Standard Edition7.27.29.2 TS2M29.3 TS1M2
Microsoft Windows Server 20087.27.29.2 TS2M29.3 TS1M2
Windows 7 Enterprise 32 bit7.27.29.2 TS2M29.3 TS1M2
Windows 7 Enterprise x647.27.29.2 TS2M29.3 TS1M2
Windows 7 Home Premium 32 bit7.27.29.2 TS2M29.3 TS1M2
Windows 7 Home Premium x647.27.29.2 TS2M29.3 TS1M2
Windows 7 Professional 32 bit7.27.29.2 TS2M29.3 TS1M2
Windows 7 Professional x647.27.29.2 TS2M29.3 TS1M2
Windows 7 Ultimate 32 bit7.27.29.2 TS2M29.3 TS1M2
Windows 7 Ultimate x647.27.29.2 TS2M29.3 TS1M2
Windows Vista7.27.29.2 TS2M29.3 TS1M2
Windows Vista for x647.27.29.2 TS2M29.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.