topic How to concatenate a culomn values into a string? in SAS Programming

How to concatenate a culomn values into a string?

marzieh — Tue, 21 Feb 2012 05:55:01 GMT

I have a table like this

data concat;

input name $;

datalines;

;

run;

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

How to concatenate a culomn values into a string?

art297 — Tue, 21 Feb 2012 06:43:14 GMT

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

data concat;

input name $;

datalines;

;

run;

proc sql noprint;

select name

into :string

separated by ","

from concat

;

quit;

%put &string.;

How to concatenate a culomn values into a string?

marzieh — Tue, 21 Feb 2012 07:05:59 GMT

Thanks, It works

How to concatenate a culomn values into a string?

Ksharp — Wed, 22 Feb 2012 11:10:06 GMT

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