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

A fix for SAS 9.1 (9.1 TS1M0) for this issue is available at:

A fix for SAS 9.1 (9.1 TS1M0) with Asian Language Support (DBCS) for this issue is available at:

A fix for SAS 9.1.2 (9.1 TS1M2) for this issue is available at:

A fix for SAS 9.1.2 (9.1 TS1M2) with Asian Language Support (DBCS) for this issue is available at: