Problem Note 12651: Missed optimization opportunity in PROC SQL when joining three or more tables
 |  |  |  |  |
Your PROC SQL query of a three or more table join may run out of resources after running for an excessive amount of time. PROC SQL misses an opportunity to optimize some three or more table joins. A Technical Support hot fix for SAS 9.1 (TS1M0) for this issue is available at: http://www.sas.com/techsup/download/hotfix/b9_sbcs_prod_list.html#012651 For customers running SAS with Asian Language Support (DBCS), this hot fix should be downloaded from: http://www.sas.com/techsup/download/hotfix/b9_dbcs_prod_list.html#012651 A Technical Support hot fix for SAS 9.1.2 (9.1 TS1M2) for this issue is available at: http://www.sas.com/techsup/download/hotfix/c9_sbcs_prod_list.html#012651 For customers running SAS with Asian Language Support (DBCS), this hot fix should be downloaded from: http://www.sas.com/techsup/download/hotfix/c9_dbcs_prod_list.html#012651
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.1 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Microsoft Windows NT Workstation | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Linux | 9.1 TS1M0 | 9.1 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M0 | 9.1 TS1M0 | ||
| z/OS | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Microsoft Windows XP Professional | 9.1 TS1M0 | 9.1 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M0 | 9.1 TS1M0 | ||
| OpenVMS Alpha | 9.1 TS1M0 | 9.1 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M0 | 9.1 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M0 | 9.1 TS1M0 | ||
| Tru64 UNIX | 9.1 TS1M0 | 9.1 TS1M0 | ||
A fix for SAS 9.1 (9.1 TS1M0) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/b9_sbcs_prod_list.html#012651A fix for SAS 9.1 (9.1 TS1M0) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/b9_dbcs_prod_list.html#012651A fix for SAS 9.1.2 (9.1 TS1M2) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/c9_sbcs_prod_list.html#012651A fix for SAS 9.1.2 (9.1 TS1M2) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/c9_dbcs_prod_list.html#012651| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> Procedures ==> SQL SAS Reference ==> SQL |
| Date Modified: | 2004-10-26 13:37:30 |
| Date Created: | 2004-06-18 15:16:08 |