how to create macro variable with ''?

[Linlin]

After I ran the code below, macro variable &mnew=a,b,c.

How can I get &mnew=’a’,’b’,’c’ by modifing my code.

Thanks - Linlin

data have;

  input c_id $;

  cards;

  a

  b

  c

   ;

data _null_;

  set have end=last;;

  length new $ 30;

retain new;

new=catx(',',new,c_id);

if last then

call symputx('mnew',new);

run;

%put &mnew;

[Tom · Accepted solution]

If you can use double quote characters instead of single quote then use the QUOTE() function.

new=catx(',',new,quote(trim(c_id)));

If you need to use single quotes then

new=catx(',',new,"'"||trim(c_id)||"'");

[Linlin]

Hi Tom,

Thank you very much!!! - Linlin