When you use the SQL procedure to rename a date column and use it in date calculations, you might encounter the following error:

This error occurs if the following is true about the query:

• There is a join of multiple database management system (DBMS) tables.
• Two or more date variables are being renamed.
• The renamed date variables are used in a date calculation.

There are two possible workarounds:

• Use a RENAME= data set option on the resulting data set.
• Divide the renaming action and the date calculations into multiple steps.

Operating System and Release Information

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