Read Access Violation errors occur when creating a long macro variable with the PROC SQL / INTO: macro interface with the SEPARATED BY clause.

Creating a very long macro variable using the PROC SQL / INTO: macro interface and the SEPARATED BY clause can cause PROC SQL to produce a Read Access Violation. If running this code interactively, the error causes the Display Manager to terminate.

A hotfix is planned for this issue.

Operating System and Release Information

data a; 
 length a $ 32767; 
 a=repeat("a",20000); 
run; 

proc sql noprint; 
  select a into :m_a separated by ' '
  from a; 
quit; 

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: