Using the SQL procedure with INSERT statement syntax, which lists the column names in parentheses, might cause a Read Access Violation to occur. The problem occurs when a column name is misspelled or when the column name does not exist in the target table.

The correct behavior is for an error similar to the following to be written to the SAS log:

See the Full Code tab in this note for an example of code that causes the Read Access Violation in SAS 9.3.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	Base SAS	Microsoft® Windows® for x64	9.3	9.4	9.3 TS1M0	9.4 TS1M0
		Microsoft Windows Server 2003 Datacenter Edition	9.3		9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise Edition	9.3		9.3 TS1M0
		Microsoft Windows Server 2003 Standard Edition	9.3		9.3 TS1M0
		Microsoft Windows Server 2003 for x64	9.3		9.3 TS1M0
		Microsoft Windows Server 2008	9.3		9.3 TS1M0
		Microsoft Windows Server 2008 R2	9.3	9.4	9.3 TS1M0	9.4 TS1M0
		Microsoft Windows Server 2008 for x64	9.3	9.4	9.3 TS1M0	9.4 TS1M0
		Microsoft Windows XP Professional	9.3		9.3 TS1M0
		Windows 7 Enterprise 32 bit	9.3		9.3 TS1M0
		Windows 7 Enterprise x64	9.3	9.4	9.3 TS1M0	9.4 TS1M0
		Windows 7 Home Premium 32 bit	9.3		9.3 TS1M0
		Windows 7 Home Premium x64	9.3		9.3 TS1M0
		Windows 7 Professional 32 bit	9.3		9.3 TS1M0
		Windows 7 Professional x64	9.3	9.4	9.3 TS1M0	9.4 TS1M0
		Windows 7 Ultimate 32 bit	9.3		9.3 TS1M0
		Windows 7 Ultimate x64	9.3		9.3 TS1M0
		Windows Vista	9.3		9.3 TS1M0
		Windows Vista for x64	9.3		9.3 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

This example intentionally causes a Read Access Violation to occur in SAS 9.3.

---

data one;                 
 x='a'; y='b';            
run;                      
                          
data two;                 
 x='c'; y='d';            
run;                      

/** column Y2 does not exist in table ONE **/                           
proc sql;                 
 insert into one (x, y2)  
 select x                 
       ,y                 
 from two;                
quit;                     
                          
                          

Type:	Problem Note
Priority:	high

Date Modified:	2014-03-24 11:46:39
Date Created:	2014-03-19 08:09:34