Problem Note 1138: Non-specific note when comparing NULL length string to numerics in SQL
PROC SQL does not return an error message when comparing a NULL length
string to a numeric variable in Version 7 and beyond. For example, the
following code:
proc sql;
select * from test
where numvar = '';
quit;
Produces the following note:
NOTE: The SAS System stopped processing this step because of errors.
To prevent this message, replace the '' with the SAS representation for
a numeric missing value (i.e. where numvar = .;).
To see the correct error message that should be produced, replace ''
with ' '.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | Base SAS | Microsoft Windows NT Workstation | 8 TS M0 | 8 TS M1 |
| OpenVMS VAX | 8 TS M0 | 8 TS M1 |
| IRIX | 8 TS M0 | 8 TS M1 |
| Solaris | 8 TS M0 | 8 TS M1 |
| 64-bit Enabled Solaris | 8 TS M0 | 8 TS M1 |
| OS/2 | 8 TS M0 | 8 TS M1 |
| ABI+ for Intel Architecture | 8 TS M0 | 8 TS M1 |
| z/OS | 8 TS M0 | 8 TS M1 |
| HP-UX | 8 TS M0 | 8 TS M1 |
| OpenVMS Alpha | 8 TS M0 | 8 TS M1 |
| 64-bit Enabled HP-UX | 8 TS M0 | 8 TS M1 |
| CMS | 8 TS M0 | 8 TS M1 |
| Microsoft Windows 95/98 | 8 TS M0 | 8 TS M1 |
| Tru64 UNIX | 8 TS M0 | 8 TS M1 |
| 64-bit Enabled AIX | 8 TS M0 | 8 TS M1 |
| AIX | 8 TS M0 | 8 TS M1 |
*
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: | low |
| Topic: | SAS Reference ==> Procedures ==> SQL
SAS Reference ==> SQL
|
| Date Modified: | 1999-09-17 00:00:00 |
| Date Created: | 1999-09-17 00:00:00 |
