SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 39269: Some future dates imported from Microsoft Excel into SAS® Enterprise Guide® might not be correct

DetailsHotfixAboutRate It

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Enterprise GuideWindows Vista4.24.3059.2 TS2M09.2 TS2M2
Microsoft Windows Server 2003 Standard Edition4.24.3059.2 TS2M09.2 TS2M2
Microsoft Windows XP Professional4.24.3059.2 TS2M09.2 TS2M2
Microsoft Windows Server 2003 Enterprise Edition4.24.3059.2 TS2M09.2 TS2M2
Microsoft® Windows® for x644.24.3059.2 TS2M09.2 TS2M2
Microsoft Windows Server 2003 Datacenter Edition4.24.3059.2 TS2M09.2 TS2M2
* 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.