Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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: