Problem Note 46832: Incorrect results might occur when processing an SQL procedure query
You might get incorrect results after running a query with PROC SQL. This problem occurs if the query contains the following:
- A join of two or more tables or views
- A predicate (or part of a predicate) that compares a column from one table to either a literal or to another column from the same table
- One or more of the following:
- An aggregate function
- An OUTER UNION operator
- A UNION or UNION ALL operator
- An INTERSECT or INTERSECT ALL operator
- An EXCEPT or EXCEPT ALL operator
To work around this issue, break up the query so that it does not meet all of the above criteria.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | Base SAS | Tru64 UNIX | 9.1 TS1M3 | 9.3 TS1M2 |
| OpenVMS Alpha | 9.1 TS1M3 | 9.3 TS1M2 |
| Linux | 9.1 TS1M3 | 9.3 TS1M2 |
| HP-UX IPF | 9.1 TS1M3 | 9.3 TS1M2 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.3 TS1M2 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.3 TS1M2 |
| Windows Vista for x64 | 9.1 TS1M3 | 9.3 TS1M2 |
| Windows Vista | 9.1 TS1M3 | 9.3 TS1M2 |
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.3 TS1M2 |
| 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 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | 9.3 TS1M2 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.3 TS1M2 |
| z/OS | 9.1 TS1M3 | 9.3 TS1M2 |
*
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 |
| Date Modified: | 2012-09-17 15:11:15 |
| Date Created: | 2012-06-18 12:09:24 |
