Problem Note 62204: Incorrect SQL code is generated when you use a missing (null) value in combination with a logical OR in a Select node
 |  |  |  |  |
When you use a Select node in SAS® Customer Intelligence, the expression uses a missing value and a logical OR operator, as follows:
However, the SQL code that is generated by the expression does not contain the missing values in the WHERE clause, as it should.
SELECT table0.CLIENTNUM AS CLIENTNUM LABEL='CLIENTNUM' FORMAT=F12.0
FROM ORADM.CLIENTS table0
WHERE table0.PSTCDAREA='AA'
FROM ORADM.CLIENTS table0
WHERE table0.PSTCDAREA='AA'
To work around this problem, do not use the logical OR operator. Instead, select the value (in this case, AA) and (MISSING) at the same time, as shown below:
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
| 64-bit Enabled AIX | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| HP-UX IPF | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Linux for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Solaris for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#62204| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-07-16 09:28:38 |
| Date Created: | 2018-04-25 12:43:36 |