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: