Concatenate strings

Valentin_HU — Wed, 30 Mar 2011 17:24:31 GMT

Hi there,
I'm not sure if this is the right place for this post, if not I'm sorry!
I have the following problem:
My data looks like that (simplified):
Text group
text1 1
text2 1
text3 1
text4 1
text1 2
text2 2
text1 3
text2 3
text3 3

Now I want to concatenate the strings in 'Text' for each group so that the data looks like that:

Text group
text1_text2_text3_text4 1
text1_text2 2
text1_text2_text3 3

Can anyone help me with this? Another question here is the maximal length of a string variable.

Thanks!

Valentin

Re: Concatenate strings

SPR — Wed, 30 Mar 2011 17:41:30 GMT

Hello Vvalentin_HU,

This is a solution:
[pre]
data i;
input Text $ group;
datalines;
text1 1
text2 1
text3 1
text4 1
text1 2
text2 2
text1 3
text2 3
text3 3
run;
data r;
retain t;
length t $100;
set i;
if First.group then t="";
t=CATX('_',t,text);
if Last.group then output;
by group;
keep t group;
run;
[/pre]
Sincerely,
SPR

topic Concatenate strings in SAS Programming

Concatenate strings

Re: Concatenate strings