Desktop productivity for business analysts and programmers

Error while storing distinct values in macro variable

Reply
Contributor brm
Contributor
Posts: 30

Error while storing distinct values in macro variable

I'm trying to store all distinct records in a macro variable.

Proc sql noprint ;
select distinct DRC_CASE_ID into : tempids separated by ',' from c;
quit;

Getting below error,how can i do it using sas

15 Proc sql;
16 select distinct DRC_CASE_ID into : tempids separated by ',' from c;
ERROR: The length of the value of the macro variable TEMPIDS (79271) exceeds the maximum length
(65534). The value has been truncated to 65534 characters.
17 quit;
Respected Advisor
Posts: 3,825

Re: Error while storing distinct values in macro variable

Hi

You hit the maximum storage capacity of macro variables in a 64bit environment.

You will have to use another technique to achieve what you're after (i.e. a join or a hash look-up).

HTH
Patrick
Ask a Question
Discussion stats
  • 1 reply
  • 139 views
  • 0 likes
  • 2 in conversation