Referring to a table that has been sorted and indexed in a correlated subquery might cause a Read-access violation when you run PROC SQL.

To temporarily work around this issue, do not presort the table to be indexed. This workaround causes the query to run longer than expected but should allow the query to execute.

To see sample code that reproduces this problem, click the Full Code tab in this note.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

data one;                             
    format a b c d  8.;               
    input a b c d ;                   
    datalines;                        
  1 25193 1 2                         
  1 25193 1 3                         
  1 25193 2 1                         
  ;                                   
  RUN;                                
                                      
proc sort data=one;                   
     by a b ;                         
run;                                  
                                      
proc sql;                             
 create index a on one;               
quit;                                 
                                      
                                      
proc sql;                             
    create table one1 as              
    select * from one as a            
    where c = (SELECT c FROM one as b 
    WHERE a.a=b.a                     
      AND b.d = 1                     
      )                               
   ;                                  
QUIT;                                 

A fix for this issue for Base SAS 9.3_M2 is available at: