SUPPORT / SAMPLES & SAS NOTES
Problem Note 19152: Inner Join code might be generated inefficiently in SAS® Enterprise Guide®
 |  |  |  |  |
The PROC SQL generated by SAS Enterprise Guide for some inner joins might be inefficient. If the PROC SQL contains more than one INNER JOIN, and all joins are inner joins, then it is usually more efficient to process multiple inner joins using FROM and WHERE clauses instead of INNER JOIN syntax.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 9.2 TS2M0 |