topic how to create macro variable with ''? in SAS Programming

how to create macro variable with ''?

Linlin — Tue, 20 Mar 2012 13:16:31 GMT

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;

;

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 — Tue, 20 Mar 2012 13:25:49 GMT

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 — Tue, 20 Mar 2012 13:32:02 GMT

Hi Tom,

Thank you very much!!! - Linlin