An SQLPLAN error might occur when you run a PROC SQL query similar to the following:

proc sql;                                    
   create table test as                         
       select RA_LOC_OUT_SEQ_NO as Loc_Seq,         
          (select count(CT2OK)                         
           from ds1                                   
           where Loc_Seq=RA_LOC_OUT_SEQ_NO          
           ) as noswipe                               
       from ds1;                                    
quit; 

The error that occurs is similar to the following:

ERROR: sqlplan internal error: Cannot find symbol Loc_Seq,
var=1, tag=0002.

The error occurs when you give a variable a new name in a query and then you use that new name within a subquery that also has an alias.

To circumvent this problem, use the original variable name in the subquery rather than the new name.

Operating System and Release Information

data ds1;                                    
ra_loc_out_Seq_no=1;                         
ct2ok='N';                                   
ra_profile_no='a';                           
                                             
PROC SQL;                                    
CREATE TABLE test AS                         
SELECT RA_LOC_OUT_SEQ_NO as Loc_Seq,         
(SELECT count(CT2OK)                         
  FROM ds1                                   
  where Loc_Seq = RA_LOC_OUT_SEQ_NO          
  ) as noswipe                               
FROM ds1;                                    
QUIT;