Problem Note 39954: Incorrect date and time formats might be generated when using "Send to Microsoft Excel" or "Export to Excel" in SAS® Enterprise Guide®
 |  |  |  |  |
The options Send to Microsoft Excel, or Export, or Export as a Step in Project might generate an incorrect format for date, time, or datetime values when displayed in Microsoft Excel. This problem will most likely occur when a German version of Microsoft Excel is being used.
To circumvent the problem, use an English version of Microsoft Excel.
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.3 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
A fix for this issue for SAS Enterprise Guide 4.305 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C44.html#39954A fix for this issue for SAS Enterprise Guide 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D18.html#39954| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-06-10 14:12:06 |
| Date Created: | 2010-06-10 10:08:32 |