When doing an outer join between 2 DBMS tables and renaming a column on the SELECT clause that is also used in the ON clause, the new alias name is submitted to the DBMS rather than the original column name. This results in the DBMS coming back with an error and thus SAS^® retrieving the entire DBMS tables and doing the join in SAS thus causing a performance degradation.

will result in new =b."x" being passed to the DBMS which results in the DBMS telling us that new column does not exist. If the column already existed then it would generate incorrect results.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :