Hi, SAS! I work in data integration studio and have problem with the length of expression: ERROR: The text expression length (65535) exceeds maximum length (65534). The text expression has been truncated to 65534 characters. It happens in my user written transform, when sas resolves macro variable: %let _OUTPUT1_col9_exp = /*{long expression, which contains very long data step code, for example: "if number=1 then do....end; if....." and has length >65535}*/; I understand, that this very long text expression assigns in macro variable, and it has length limit 65534 but may be someone faced such problem and successfully solved it. My user written transformation doesn't allow me to split this macro variable into several macro variables, because it use in data step code: .......... data &&_OUTPUT&mvI.(keep=&&_OUTPUT&mvI._keep &&_OUTPUT&mvI._options) %if "&&_OUTPUT&mvI._memtype" eq "VIEW" %then / view=&&_OUTPUT&mvI.; attrib /*{attrib code}*/ set %do mvI=0 %to %eval(&_INPUT_count - 1); &&_INPUT&mvI. (in=in_&mvI. &&_INPUT&mvI._options) %end; %do mvI=0 %to %eval(&&_OUTPUT&mvT._col_count - 1); %if "&&_OUTPUT_col&mvI._exp" ne "" %then %do; &&_OUTPUT&mvT._col&mvI._exp; {<- this is the place, where this macro variable resolves} %end; %end; run; ....... I tried to split my code into several expressions: %let _OUTPUT1_col9_exp = /*{part 1 of long expression, which contains very long data step code, for example: "if number=1 then do....end; if....." and has length >65535}*/;
%let _OUTPUT1_col10_exp = /*{part 2 of long expression, which contains very long data step code, for example: "if number=1 then do....end; if....." and has length >65535}*/;
%let _OUTPUT1_col11_exp = /*{part 3 of long expression, which contains very long data step code, for example: "if number=1 then do....end; if....." and has length >65535}*/;
...... but i have limited quantity of _OUTPUT1_col{n}_exp macrovariables, and it is not enough to fit this long expression. Sorry for my English, I'm from Belarus😶 and i don't hope that someone can help me with this problem.
... View more