topic Re: Concatenating text strings from multiple observations on a variable in SAS Programming

Concatenating text strings from multiple observations on a variable

JasonL — Tue, 07 Jan 2014 20:24:46 GMT

I need to concatenate the following text strings from multiple records in a variable Var1

Var1

into something like

"01", "02", "03", "04", ......

and store this long string in a macro variable.

Is there an easy way to do it?

Thanks.

Re: Concatenating text strings from multiple observations on a variable

Reeza — Tue, 07 Jan 2014 20:33:12 GMT

Use SQL and into with separated by option. Note that the quotes are: single, double, comma, double, single. Also that the first and end quotes are missing, but you can easily get around that by including them in your query.

Proc SQL noprint;

select name into :name_list separated by '" , "'

from sashelp.class;

quit;

%put &name_list;

%put "&name_list";

Re: Concatenating text strings from multiple observations on a variable

data_null__ — Tue, 07 Jan 2014 20:44:09 GMT

QUOTE function

18         Proc SQL noprint;
19            select quote(strip(name)) into :name_list separated by ','
20            from sashelp.class;
21            quit;
22            run;
23         %put NOTE: &=name_list;
NOTE: 
NAME_LIST="Alfred","Alice","Barbara","Carol","Henry","James","Jane","Janet","Jeffrey","John","Joyce","Judy","Louise","Mary","Philip"
,"Robert","Ronald","Thomas","William"

Re: Concatenating text strings from multiple observations on a variable

JasonL — Tue, 07 Jan 2014 20:52:38 GMT

Thank you both! It works!