DATA Step, Macro, Functions and more

Concatenate strings

Reply
Occasional Contributor
Posts: 9

Concatenate strings

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
Super Contributor
Super Contributor
Posts: 365

Re: Concatenate strings

Posted in reply to Valentin_HU
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
Ask a Question
Discussion stats
  • 1 reply
  • 1424 views
  • 0 likes
  • 2 in conversation