How to concatenate a culomn values into a string?

[marzieh]

I have a table like this

data concat;

input name $;

datalines;

a

b

c

d

;

run;

How can I turn values of culomn 'name' into a single string of  a, b, c, d?

[art297 · Accepted solution]

Not sure how you want to use it, but one way would be:

data concat;

input name $;

datalines;

a

b

c

d

;

run;

proc sql noprint;

  select name

    into :string

      separated by ","

        from concat

  ;

quit;

%put &string.;

[marzieh]

Thanks, It works

[Ksharp]

Or data step.

data concat;
input name $;
datalines;
a
b
c
d
;
run;
data want(keep=len);
 set concat end=last;
 length len $ 32767;
 retain len;
 len=catx(', ',len,name);
 if last then output;
run;

Ksharp