When you use the SQL procedure to join multiple database management set (DBMS) tables that use the same libref, incorrect results might occur. This issue can occur when all of the following are true:

• A view that references one of the DBMS tables is created.
• A second view is created where the following is true about the view:
• The first view is joined with the second DBMS table.
• A same-named variable is selected from both the first view and from the DBMS table.
• One of those same-named variables is given a new unique name.
• A third query references the second view and includes a WHERE clause where the original same-named variables are being compared using syntax similar to this:
  v1.var < v1.alias_name

When all of these conditions exist, the generated code will include a WHERE clause that compares the wrong variables. This is what is passed to the DBMS:

This is what should be passed to the DBMS:

The only workaround is to create a table rather than the second view.

Operating System and Release Information

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

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