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;