Hi All , I am also getting " ERROR: The length of the value of the macro variable UNIT_VAR_LIST (65540) exceeds the maximum length (65534). The value has been truncated to 65534 characters." but when I searched I read about option "mexecsize" which is available to solve this issue but I do not know how to use "mexecsize" option . Can anyone help me on this this issue ? I Have written this code to format all SAS varibles (FORMAT &UNIT_VAR_LIST 9. ; FORMAT &DLLR_VAR_LIST 9.2;) at once. libname lib '/my/sas/var_size_issue';
*proc options mexecsize=MAX;
*run;
*MEXECSIZE = MAX;
PROC SQL NOPRINT;
CREATE TABLE lib.VAR_NAMES AS
SELECT NAME FROM DICTIONARY.COLUMNS
WHERE libname ='LIB' AND memname ='MGR';
SELECT COMPRESS(NAME) INTO :UNIT_VAR_LIST SEPARATED BY " " FROM lib.VAR_NAMES WHERE UPCASE(name) LIKE '%unit%' OR
UPCASE(name) LIKE UPCASE('%UNIT%');
SELECT COMPRESS(NAME) INTO :DLLR_VAR_LIST SEPARATED BY " " FROM lib.VAR_NAMES WHERE UPCASE(name) LIKE '%dllr%' OR
UPCASE(name) LIKE '%DLLR%';
QUIT;
... View more