Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

When you perform a query containing an in-line view that created a new column and that new column is used in a subsequent, correlated subquery, an error similar to the following might occur:

ERROR: sqlplan internal error: Cannot find symbol #TEMG001,
var=1, tag=0001. This message can be caused by attempting to 
make correlated references between two different items on a 
single FROM clause.

The only workaround is to break the query and process it in multiple steps.

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:

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