Problem Note 55062: The INTNX function sets the DATA step variable _ERROR_ to 1 if a missing value is used as an argument in SAS® 9.4
If you use a missing value as an argument to the INTNX function in SAS 9.4, the automatic DATA step variable _ERROR_ is set to 1. A message like the following is also issued in the SAS® log:
NOTE: Argument 2 to function INTNX('day',.,1) at line 2373 column 4 is
invalid.
date=. y=. _ERROR_=1 _N_=1
In earlier releases of SAS®, only the following note is issued if a missing value is used as an argument to the INTNX function:
NOTE: Mathematical operations could not be performed at the following
places. The results of the operations have been set to missing
values.
This note is also written to the SAS log in SAS 9.4.
The sample code on the Full Code tab provides a circumvention for this issue.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | Base SAS | Microsoft Windows 8.1 Pro | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8 Pro x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8 Enterprise x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 9.4 TS1M0 | 9.4 TS1M3 |
z/OS | 9.4 TS1M0 | 9.4 TS1M3 |
Solaris for x64 | 9.4 TS1M0 | 9.4 TS1M3 |
HP-UX IPF | 9.4 TS1M0 | 9.4 TS1M3 |
64-bit Enabled Solaris | 9.4 TS1M0 | 9.4 TS1M3 |
64-bit Enabled HP-UX | 9.4 TS1M0 | 9.4 TS1M3 |
64-bit Enabled AIX | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2012 Std | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2012 R2 Std | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2012 Datacenter | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2008 for x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows Server 2008 R2 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.4 TS1M0 | |
Z64 | 9.4 TS1M0 | 9.4 TS1M3 |
Windows 7 Professional x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Windows 7 Enterprise x64 | 9.4 TS1M0 | 9.4 TS1M3 |
Linux for x64 | 9.4 TS1M0 | 9.4 TS1M3 |
*
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.
The sample code below illustrates how you can conditionally execute the INTNX function to prevent _ERROR_ from being set to 1 if an argument to the INTNX function is a missing value.
data a;
date=.;
if date ne . then y=intnx('day',date,1);
else put "DATE is a missing value.";
run;
Starting in SAS
® 9.4, the INTNX function sets the DATA step variable _ERROR_ to 1 if a missing value is used as an argument. An invalid argument message is also issued. This differs from earlier releases of SAS
®.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2015-01-26 11:00:15 |
Date Created: | 2015-01-22 16:38:31 |