Problem Note 37657: WHERE ALSO and WHERE SAME AND statements do not work with OPEN=DEFER option on SET statement
Using WHERE ALSO or WHERE SAME AND statements when using the OPEN=DEFER SET statement option does not work. For all the non-first data sets listed, only the last WHERE clause listed is used. The log file shows that SAS is only using the last WHERE clause.
The workaround is to use one WHERE statement with AND between the clauses or to remove the OPEN=DEFER SET statement option.
Operating System and Release Information
| SAS System | Base SAS | 64-bit Enabled Solaris | 9.1 TS1M3 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 9.1 TS1M3 | |
| Windows Vista | 9.1 TS1M3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
| z/OS | 9.1 TS1M3 | |
| HP-UX IPF | 9.1 TS1M3 | |
| Linux | 9.1 TS1M3 | |
| OpenVMS Alpha | 9.1 TS1M3 | |
| Tru64 UNIX | 9.1 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.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> Statements ==> Action ==> WHERE
|
| Date Modified: | 2009-11-20 10:29:42 |
| Date Created: | 2009-10-30 10:30:32 |