Problem Note 37936: The ANYDTDTM informat does not read time values without seconds correctly prior to SAS® 9.2
Prior to SAS® 9.2, if a datetime value did not include seconds, the ANYDTDTMw.d informat would not read the value properly. It would return a missing value.
This issue is fixed beginning in SAS 9.2.
Operating System and Release Information
| SAS System | Base SAS | Tru64 UNIX | 9.1 TS1M0 | 9.2 TS1M0 |
| OpenVMS Alpha | 9.1 TS1M0 | 9.2 TS1M0 |
| Linux | 9.1 TS1M0 | 9.2 TS1M0 |
| HP-UX IPF | 9.1 TS1M0 | 9.2 TS1M0 |
| 64-bit Enabled Solaris | 9.1 TS1M0 | 9.2 TS1M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M0 | 9.2 TS1M0 |
| 64-bit Enabled AIX | 9.1 TS1M0 | 9.2 TS1M0 |
| Microsoft Windows XP Professional | 9.1 TS1M0 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.2 TS1M0 |
| Microsoft Windows NT Workstation | 9.1 TS1M0 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | |
| Microsoft Windows 2000 Server | 9.1 TS1M0 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M0 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M0 | 9.2 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.2 TS1M0 |
| z/OS | 9.1 TS1M0 | 9.2 TS1M0 |
*
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.
Prior to SAS 9.2 TS1M0, the ANYDTDTMw.d informat required the seconds portion to be present in a datetime value or a missing value would result.
data a;
input x anydtdtm22.;
format x datetime22.;
datalines;
07/22/2005 12:45
22072005 12:45
2005-07-22 12:45
;
run;
proc print;
run;
| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> Informats ==> Date and Time ==> ANYDTDTM
|
| Date Modified: | 2009-11-20 14:48:28 |
| Date Created: | 2009-11-20 12:35:59 |