topic Re: ERROR: The text expression length (65572) exceeds maximum length (65534). The text expression ha in SAS Programming

ERROR: The text expression length (65572) exceeds maximum length (65534). The text expression has

ari — Tue, 17 Dec 2019 10:40:48 GMT

Dear Experts,

I encountered this error from running this code:

ERROR: The text expression length (65572) exceeds maximum length (65534). The text expression has
been truncated to 65534 characters.

proc sql;
select catx("=", NAME, quote(trim(dscr)))
into :label_list separated by " "
from test;
quit;

Is there a way to solve this error?

Please let me know.

Many thanks in advance.

Re: ERROR: The text expression length (65572) exceeds maximum length (65534). The text expression ha

gamotte — Tue, 17 Dec 2019 10:51:49 GMT

Hello,

What are you creating this macrovariables list for ?

Macro language is not meant to be used to manipulate data.

So the solution would be not to create this list of macrovariables and

use bases SAS language to achieve your goal.

Re: ERROR: The text expression length (65572) exceeds maximum length (65534). The text expression ha

Kurt_Bremser — Tue, 17 Dec 2019 11:47:30 GMT

@ari wrote:

Is there a way to solve this error?

Yes. Stop abusing macro variables for things they are not meant for.

DATA belongs in DATASETS.

You can always use your above select as a sub-select in SQL, load a hash object in a data step from it, or create a format. Or do a join, which will scale up until you run out of disk storage.

Re: ERROR: The text expression length (65572) exceeds maximum length (65534). The text expression ha

s_lassen — Tue, 17 Dec 2019 13:27:36 GMT

Sounds like you are trying to generate a list of variable labels, to use in another program, e.g.:

Data want;
  set have;
  label &label_list;
run;

I would consider writing the code to a temporary file instead:

filename tempsas temp;
Data _null_;
  file tempsas;
  put 'label';
  do _N_=1 to nobs;
    set test nobs=nobs;
    dscr=quote(trim(dscr),"'");
    put name '=' dscr;
    end;
  put ';';
end;

data want;
  set have;
  %include tempsas;
run;