Problem Note 36136: An error occurs in a SAS® 9.2 automatic macro variable when you submit large SQL procedure queries that invoke the implicit Pass-Through facility
 |  |  |  |
In SAS 9.2, the global automatic macro variable SYS_SQL_IP_STMT is created when PROC SQL invokes the implicit Pass-Through facility. This macro variable contains the SELECT statement, which is to be passed down to the database.
When the SELECT statement in SYS_SQL_IP_STMT exceeds a length of 65,534 bytes, an error similar to the following is written to the SAS Log:
ERROR: The length of the value of the macro variable SYS_SQL_IP_STMT (76533) exceeds the maximum length (65534). The value has been truncated to 65534 characters.
PROC SQL queries that are generated by SAS solutions are more susceptible to this error. Such queries use a drag-and-drop graphical user interface. As a result, the queries generated from this method tend to be much larger than queries written manually.
This problem is fixed at SAS 9.2 TS2M2.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.2 TS1M0 | 9.2 TS2M2 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Windows Vista | 9.2 TS1M0 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 9.2 TS1M0 | 9.2 TS2M2 | ||
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.2 TS2M2 | ||
| 64-bit Enabled Solaris | 9.2 TS1M0 | 9.2 TS2M2 | ||
| HP-UX IPF | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Linux | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Linux for x64 | 9.2 TS1M0 | 9.2 TS2M2 | ||
| OpenVMS on HP Integrity | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Solaris for x64 | 9.2 TS1M0 | 9.2 TS2M2 | ||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-12-15 16:33:48 |
| Date Created: | 2009-06-04 09:45:21 |