Problem Note 45227: Invalid format of DATE18. generated by EFI, PROC IMPORT and IMPORT WIZARD
 |  |  |  |
When EFI, PROC IMPORT, or the IMPORT WIZARD encounter a datetime value with zeros for the time portion, a format of DATE18. is assigned. DATE18. is invalid due to the width portion and therefore an ERROR is returned for the FORMAT statement in the generated DATA step code in the SAS log. The problem has been fixed in SAS 9.3 TS1M1.
If you are using SAS 9.3 and PROC IMPORT to read the external file, you can do one of the following workarounds:
1) Recall the generated DATA step code from the SAS log assuming you are running SAS interactively. Then modify the FORMAT statement for the variable with the invalid width by changing the width to 9. in place of 18. You can recall the generated DATA step code by doing a RUN-RECALL LAST SUBMIT after the PROC IMPORT.
2) Use a DATA step with INFILE and INPUT statements instead of PROC IMPORT to read the external file.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP Professional | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Enterprise 32 bit | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Enterprise x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Home Premium 32 bit | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Home Premium x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Professional 32 bit | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Professional x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Ultimate 32 bit | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Ultimate x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows Vista | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows Vista for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled AIX | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled HP-UX | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled Solaris | 9.3 TS1M0 | 9.3 TS1M1 | ||
| HP-UX IPF | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Linux | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Linux for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Solaris for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> Formats ==> Date and Time ==> DATETIME SAS Reference ==> Procedures ==> IMPORT |
| Date Modified: | 2012-01-13 15:16:13 |
| Date Created: | 2011-12-28 08:22:49 |