Problem Note 10958: "ERROR: Invalid date/time/datetime constant " 0"dt"
in CPREDUCE
CPREDUCE may generate the following when a table is reduced for the
first time, and the SAS system option MISSING is set to MISSING=0:
CPREDUCE "ERROR: INVALID DATE/TIME/DATETIME CONSTANT " 0"DT."
For a table being reduced for the first time, the metadata for a
particular field is set to missing. If the MISSING option were set to
MISSING=., this missing value would be interpreted correctly as:
" ."dt;
However, if MISSING is set to MISSING=0, the datetime value becomes:
" 0"dt;
which is an invalid datetime constant.
This may be circumvented by coding
OPTIONS MISSING=.;
before the CPREDUCE macro invocation.
Operating System and Release Information
| SAS System | SAS IT Resource Management-Server | z/OS | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Microsoft Windows 95/98 | 2.6 | | 8.2 TS2M0 | |
| Microsoft Windows 2000 Advanced Server | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Datacenter Server | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Server | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Professional | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Microsoft Windows NT Workstation | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Datacenter Edition | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Enterprise Edition | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Standard Edition | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Microsoft Windows XP Professional | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Windows Millennium Edition (Me) | 2.6 | | 8.2 TS2M0 | |
| 64-bit Enabled AIX | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| 64-bit Enabled HP-UX | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| 64-bit Enabled Solaris | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| AIX | 2.6 | | 8.2 TS2M0 | |
| HP-UX | 2.6 | | 8.2 TS2M0 | |
| Linux | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
| Solaris | 2.6 | | 8.2 TS2M0 | |
| Tru64 UNIX | 2.6 | 2.7 | 8.2 TS2M0 | 9.1 TS1M3 SP4 |
*
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: | Problem Note |
| Priority: | medium |
| Topic: | System Administration ==> Servers
|
| Date Modified: | 2008-01-22 15:38:29 |
| Date Created: | 2003-09-30 15:03:32 |
