SUPPORT / SAMPLES & SAS NOTES
Problem Note 30807: SAS® Enterprise Guide® executes a FORMAT clause in PROC SQL which might cause performance problems
 |  |  |  |  |
SAS Enterprise Guide executes a FORMAT clause in PROC SQL which might cause slow performance when running queries. The slow performance will likely be noticeable for large DB2 or Oracle tables.
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 Server 2003 Datacenter Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||