Error while storing distinct values in macro variable

brm — Mon, 06 Jun 2011 18:25:17 GMT

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;

Re: Error while storing distinct values in macro variable

Patrick — Mon, 06 Jun 2011 20:36:47 GMT

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

topic Error while storing distinct values in macro variable in SAS Enterprise Guide

Error while storing distinct values in macro variable

Re: Error while storing distinct values in macro variable