SUPPORT / SAMPLES & SAS NOTES
Problem Note 62724: A WHERE clause that contains an OR condition returns incorrect results when the first two arguments of the OR condition are the same
 |  |  |  |  |
If you use a WHERE clause that contains an OR condition and the first two arguments in the OR condition are identical, an incorrect number of observations might be returned.
The following code example illustrates the issue. After the code executes, zero observations occur, but the expectation is that one observation should be returned:
data test;
var1="abc001"; var2="LOOK FOR ME(HERE)"; output;
var1="def001"; var2="I AM NOT HERE "; output;
run;
var1="abc001"; var2="LOOK FOR ME(HERE)"; output;
var1="def001"; var2="I AM NOT HERE "; output;
run;
data ex1;
set test;
where (findw("LOOK FOR ME",strip(upcase(var1)))) or
(findw("LOOK FOR ME",strip(upcase(scan(var2,1,'('))),' '));
run;
set test;
where (findw("LOOK FOR ME",strip(upcase(var1)))) or
(findw("LOOK FOR ME",strip(upcase(scan(var2,1,'('))),' '));
run;
No notes, warnings, or errors are issued in the SAS® log to indicate that an incorrect number of observations has been returned.
A workaround is to substitute an IF statement in place of the WHERE clause. Using an IF statement in the code example above returns the correct expected number of observations.
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 | Base SAS | Solaris for x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 |
| Linux for x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 8 Pro x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft® Windows® for x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| z/OS 64-bit | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| z/OS | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||