Usage Note 15676: Improved DATE,TIME, and DATETIME sampling in EFI, PROC IMPORT, and
Import Wizard in SAS 9.2
Beginning in SAS 9.2, the Base SAS EFI, PROC IMPORT, and Import Wizard
sampling algorithm used to determine if a value is a DATE, TIME, or
DATETIME has been changed. The value is read in using both a TIME and
DATETIME INFORMAT, and the results of those two reads are used to
determine the correct informat for the input value. The algorithm is
illustrated below.
Time Informat Datetime Informat Read Value As
------------- ----------------- -------------
missing non-missing, timepart(datetime) eq 0 date
missing non-missing, timepart(datetime) ne 0 datetime
non-missing missing. or eq time value time
missing missing character
For consistent results, use colons rather than slashes as separators
between the hours, minutes, and seconds of time values. Using slashes
may cause the value to be incorrectly read as a date.
Due to the first sampling guideline, if a DATETIME has an empty time
portion (e.g. 00:00:00) the value is read as a date, not a datetime as
in previous releases.
Operating System and Release Information
SAS System | Base SAS | Microsoft Windows XP Professional | 9.2 | | | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 | | | |
Microsoft Windows XP 64-bit Edition | 9.2 | | | |
Microsoft Windows Server 2003 Standard Edition | 9.2 | | | |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 | | | |
Microsoft Windows 2000 Professional | 9.2 | | | |
Microsoft Windows 2000 Server | 9.2 | | | |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 | | | |
Microsoft Windows 2000 Advanced Server | 9.2 | | | |
Microsoft Windows 2000 Datacenter Server | 9.2 | | | |
Solaris | 9.2 | | | |
64-bit Enabled Solaris | 9.2 | | | |
HP-UX | 9.2 | | | |
HP-UX IPF | 9.2 | | | |
64-bit Enabled HP-UX | 9.2 | | | |
OpenVMS Alpha | 9.2 | | | |
64-bit Enabled AIX | 9.2 | | | |
AIX | 9.2 | | | |
*
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.
Type: | Usage Note |
Priority: | |
Topic: | SAS Reference ==> Procedures ==> IMPORT Common Programming Tasks ==> Reading and Writing External Data ==> EFI Common Programming Tasks ==> Reading and Writing External Data ==> with PROC IMPORT
|
Date Modified: | 2008-03-26 11:09:23 |
Date Created: | 2005-06-28 15:44:43 |