Problem Note 64651: The error "The text expression length . . . exceeds maximum length" appears after using a %SUPERQ function and a text-string value greater than 32K
 |  |  |  |  |
You submit code that contains the %SUPERQ function, and the function contains a value that is greater than 32,000 characters. The following inaccurate messages then appear in the SAS® log:
ERROR: The text expression length (-32767) exceeds maximum length (65534). The text expression has been truncated to 65534 characters.
ERROR: Maximum level of nesting of macro functions exceeded
ERROR: Maximum level of nesting of macro functions exceeded
This code example can generate the errors:
data _null_;
length x $ 32767;
x = repeat('x',32767);
call symput('x',x);
run;
%put Length of mvar: %length(&x);
%let x2=%superq(x);
%let y=1;
%let x=&x&y;
%put Length of mvar: %length(&x);
%let x2=%superq(x);
length x $ 32767;
x = repeat('x',32767);
call symput('x',x);
run;
%put Length of mvar: %length(&x);
%let x2=%superq(x);
%let y=1;
%let x=&x&y;
%put Length of mvar: %length(&x);
%let x2=%superq(x);
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.4 TS1M5 | |
| z/OS 64-bit | 9.4 TS1M5 | |||
| Microsoft® Windows® for x64 | 9.4 TS1M5 | |||
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M5 | |||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M5 | |||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M5 | |||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M5 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M5 | |||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M5 | |||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M5 | |||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M5 | |||
| Microsoft Windows 10 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2008 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M5 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M5 | |||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M5 | |||
| Microsoft Windows Server 2012 Std | 9.4 TS1M5 | |||
| Microsoft Windows Server 2016 | 9.4 TS1M5 | |||
| Windows 7 Enterprise 32 bit | 9.4 TS1M5 | |||
| Windows 7 Enterprise x64 | 9.4 TS1M5 | |||
| Windows 7 Home Premium 32 bit | 9.4 TS1M5 | |||
| Windows 7 Home Premium x64 | 9.4 TS1M5 | |||
| Windows 7 Professional 32 bit | 9.4 TS1M5 | |||
| Windows 7 Professional x64 | 9.4 TS1M5 | |||
| Windows 7 Ultimate 32 bit | 9.4 TS1M5 | |||
| Windows 7 Ultimate x64 | 9.4 TS1M5 | |||
| 64-bit Enabled AIX | 9.4 TS1M5 | |||
| 64-bit Enabled Solaris | 9.4 TS1M5 | |||
| HP-UX IPF | 9.4 TS1M5 | |||
| Linux for x64 | 9.4 TS1M5 | |||
| Solaris for x64 | 9.4 TS1M5 | |||
A fix for this issue for Base SAS 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D9T.html#64651
If a text string has a value that is greater than 32,000 and it is used with a %SUPERQ function, incorrect errors are generated. The text of the messages is "The text expression length...exceeds maximum length....The text expression has been truncated..." and "Maximum level of nesting...exceeded."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-10-02 13:36:18 |
| Date Created: | 2019-08-20 14:40:50 |