Providing software solutions since 1976
Training & Bookstore
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.
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: