Problem Note 39269: Some future dates imported from Microsoft Excel into SAS® Enterprise Guide® might not be correct
 |  |  |  |  |
Dates after 2/28/4000 are handled incorrectly when imported from Microsoft Excel. Specifically, the dates are off by one day because of the way that the Microsoft Jet Engine handles leap years. Dates after 2/28/8000 are off by two days.
As a workaround, manually change the informat in the Import Task from date9. to mmddyy10.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Windows Vista | 4.2 | 4.305 | 9.2 TS2M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.305 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 4.2 | 4.305 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.305 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft® Windows® for x64 | 4.2 | 4.305 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.305 | 9.2 TS2M0 | 9.2 TS2M2 | ||
A fix for this issue for SAS Enterprise Guide 4.305 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C44.html#39269A fix for this issue for SAS Enterprise Guide 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D18.html#39269A fix for this issue for SAS Enterprise Guide 4.305 on SAS 9.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E66.html#39269| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-06-03 10:07:27 |
| Date Created: | 2010-04-05 15:56:57 |