Error while storing distinct values in macro variable

[brm]

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;

[Patrick]

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