SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 52588: Errors might occur in SAS® 9.3 when you use the INSERT statement in PROC SQL

DetailsCodeAboutRate It

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:
ERROR: The following columns were not found in the contributing tables: YYY.

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemBase SASMicrosoft® Windows® for x649.39.49.3 TS1M09.4 TS1M0
Microsoft Windows Server 2003 Datacenter Edition9.39.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.39.3 TS1M0
Microsoft Windows Server 2003 Standard Edition9.39.3 TS1M0
Microsoft Windows Server 2003 for x649.39.3 TS1M0
Microsoft Windows Server 20089.39.3 TS1M0
Microsoft Windows Server 2008 R29.39.49.3 TS1M09.4 TS1M0
Microsoft Windows Server 2008 for x649.39.49.3 TS1M09.4 TS1M0
Microsoft Windows XP Professional9.39.3 TS1M0
Windows 7 Enterprise 32 bit9.39.3 TS1M0
Windows 7 Enterprise x649.39.49.3 TS1M09.4 TS1M0
Windows 7 Home Premium 32 bit9.39.3 TS1M0
Windows 7 Home Premium x649.39.3 TS1M0
Windows 7 Professional 32 bit9.39.3 TS1M0
Windows 7 Professional x649.39.49.3 TS1M09.4 TS1M0
Windows 7 Ultimate 32 bit9.39.3 TS1M0
Windows 7 Ultimate x649.39.3 TS1M0
Windows Vista9.39.3 TS1M0
Windows Vista for x649.39.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.