Problem Note 1251: Different results generated with outer join on NULL values
PROC SQL outer joins generate different results than Teradata outer
joins if the key variables contain NULL values. Since SAS does not have
the concept of NULLS, they are treated as missing values. A missing
value is equal to a missing value. However, a NULL is not equal to
another NULL. A NULL is the absence of a value.
The problem has been fixed in Release 8.1 TS1M0. Prior to that the
only workaround was to use the PROC SQL Pass-Through facility and
submit the query directly to Teradata.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Teradata | z/OS | 8 TS M0 | 8.1 TS1M0 |
| ABI+ for Intel Architecture | 8 TS M0 | 8.1 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.
| Type: | Problem Note |
| Priority: | alert |
| Topic: | SAS Reference ==> Procedures ==> ACCESS
|
| Date Modified: | 2000-06-21 15:44:00 |
| Date Created: | 1999-10-18 00:00:00 |
