In Base SAS^®, SQLPLAN errors might occur if any of the following is true for the SQL procedure query:

• New variables are created based on other existing variables
• A second new variable is created based on the first set of new variables created
• The second new variable is used on a HAVING clause

To work around the issue, use the code that was used to create the second new variable on the HAVING clause rather than using the new variable name.