concatenate string variable

[mrom34]

Hello,

I have a string variable and 80 rows. I would like to concatenate all rows to create only one string varaible.
I tried to use "remain" function, but it seems it does not work.

Could you help me?

Regards

Romain

 

[klaz2002]

mrom34,
REMAIN function? I don't think there is a function named REMAIN. What you need to do is use the retain statement and a trim function.

example with a column of data named yourtext.

data test;
  set yourdata;
  length newstring $2000;
  retain newstring;
  newstring = trim(newstring)||' '||trim(yourtext);
run;

I hope that this helps you out.
Klaz