Problem Note 37149: Sending or copying certain data to Microsoft Excel might alter the data when using SAS® Enterprise Guide®
 |  |  |  |  |
After using Send to Microsoft Excel on a SAS data set, the resulting data in Microsoft Excel might be incorrect. This problem will most likely occur for data represented with exponential notation. For example, after using Send to Microsoft Excel, the value 1.23456E10 in SAS Enterprise Guide might display in Excel as 12345600000.
To circumvent the problem, use Export instead of Send To.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
A fix for this issue for SAS Enterprise Guide 4.22 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A53.html#37149| Type: | Problem Note |
| Priority: | high |
| Topic: | Third Party ==> Products ==> Microsoft Office |
| Date Modified: | 2009-09-14 11:27:22 |
| Date Created: | 2009-09-10 16:55:08 |