If an SQL procedure (PROC) query includes the following, an incomplete query might be submitted to the database management system (DBMS):

• Multiple DBMS tables are being accessed via a LIBNAME engine
• A DBMS table is subsetted with a subquery that contains both inner and outer joins with multiple DBMS tables
• The subquery also contains a WHERE clause that further subsets the results of the join

The query that is submitted to the DBMS might be missing the WHERE conditions that existed in the original query. The lack of WHERE conditions might lead to more rows than would have been expected had the WHERE clause been included. This occurs because the extra rows are those that would not have met the condition(s) in the WHERE clause.

The code that is submitted might look like the following. (Note: This code has been reformatted for ease of reading.)

Workaround

Operating System and Release Information

A fix for this issue for Base SAS 9.21_M3 is available at:

A fix for this issue for Base SAS 9.3_M2 is available at: