title: SAS length of the value of the macro variable exceeds the maximum length
body: <p>Hi I am trying to call a macro for each row in the data set using the code below</p>
  
  <pre><code>proc sql;
  select cats('%run_procreg(name=',name,',month=',month,')') into :macrocalllist
    separated by ' ' from dataset_a;
  quit;
  
  
  &amp;macrocalllist;
  </code></pre>
  
  <p>I am getting the 'variable maximum length' error:</p>
  
  <blockquote>
    <p>SAS length of the value of the macro variable MACROCALLLIST (65540)
    exceeds the maximum length (65534). The value has been<br>
    truncated to 65534 characters.</p>
  </blockquote>
  
  <p>because of the number of rows in the data set. Could you suggest a work-around?</p>
  
  <p>Thank you,</p>