16234 - READ ACCESS VIOLATION in SAS 9 PROC SQL when joining four or more large tables

Problem Note 16234: READ ACCESS VIOLATION in SAS 9 PROC SQL when joining four or more large tables

Joining four or more large tables in SAS 9.1.3 PROC SQL can result in READ ACCESS VIOLATION messages.

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

Product Family	Product	System	SAS Release
Product Family	Product	System	Reported	Fixed*
SAS System	Base SAS	Microsoft Windows XP Professional	9.1 TS1M3	9.2
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.1 TS1M3	9.2
		Microsoft Windows NT Workstation	9.1 TS1M3	9.2
		Microsoft Windows XP 64-bit Edition	9.1 TS1M3	9.2
		Microsoft Windows Server 2003 Standard Edition	9.1 TS1M3	9.2
		Microsoft Windows 2000 Server	9.1 TS1M3	9.2
		Microsoft Windows Server 2003 Enterprise Edition	9.1 TS1M3	9.2
		Microsoft Windows Server 2003 Datacenter Edition	9.1 TS1M3	9.2
		Microsoft Windows 2000 Datacenter Server	9.1 TS1M3	9.2
		Microsoft Windows 2000 Professional	9.1 TS1M3	9.2
		Microsoft Windows 2000 Advanced Server	9.1 TS1M3	9.2
		Linux	9.1 TS1M3	9.2
		64-bit Enabled Solaris	9.1 TS1M3	9.2
		z/OS	9.1 TS1M3	9.2
		Linux on Itanium	9.1 TS1M3	9.2
		HP-UX IPF	9.1 TS1M3	9.2
		64-bit Enabled HP-UX	9.1 TS1M3	9.2
		OpenVMS Alpha	9.1 TS1M3	9.2
		64-bit Enabled AIX	9.1 TS1M3
		Tru64 UNIX	9.1 TS1M3	9.2

* 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.

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 :

Type:	Problem Note
Priority:	high
Topic:	SAS Reference ==> Procedures ==> SQL SAS Reference ==> SQL

Date Modified:	2005-11-08 14:38:00
Date Created:	2005-09-27 11:44:42