Incorrect results for Lookup transformations can be generated when columns with the same name exist in both source and dimension tables. 

The problem can occur when values for columns with the same name are needed in the fact table that is generated by the transformation. You must rename the column in either the source or dimension table to output both values to the fact table. Incorrect results can be generated when you rename the column in the source table. The new column that is written to the fact table contains the value from the dimension table.

A workaround is to rename the column in the dimension table. 

This issue has separate hot fixes for different releases of SAS^® 9.4.

SAS^® 9.4M8 and SAS^® 9.4M9

In SAS^® 9.4M7, a hot fix was provided to correct the problem by modifying the source code generated to rename the columns in the source and target tables. This change caused errors in some jobs in SAS 9.4M8 and SAS 9.4M9. The errors include: 

or 

Other reported issues include: 

• missing column names in the KEEP statement in the SAS DATA Step code used to perform lookups
• RENAME statements that list columns that do not exist in the table
• incorrect results
• calculated columns that result in missing values
• code that is generated in SAS^® Data Integration Studio differs from code that has been deployed previously

Click the Hot Fix tab in this note to access the relevant hot fix for your release.

Operating System and Release Information

A fix for this issue for SAS Middle Tier 9.4_M9 is available at:

A fix for this issue for SAS Management Console 9.4_M9 is available at:

A fix for this issue for SAS Management Console 9.4_M8 is available at:

A fix for this issue for Data Integration Studio 4.7_M8 is available at:

A fix for this issue for SAS Middle Tier 9.4_M8 is available at:

A fix for this issue for SAS Management Console 9.4_M7 is available at:

A fix for this issue for SAS Middle Tier 9.4_M7 is available at:

A fix for this issue for Data Integration Studio 4.7_M7 is available at: