String Concat

[nickdel]

Hi, lets say i have the following dataset...

data test1;
input var1 $;

datalines;
a 
b 
c
e 
f
;
run;

and i want to concatenate var1 into one big string i.e. abce...
I've tried this but it doesn't seem to work and I really cant figure out why!

data test2;
	set Test1;
	retain mstr;

	if _n_ = 1 then mstr = var1;
	else
		mstr = mstr||var1;
run;

All suggestions welcome!

Thanks

Nick

 

[nickdel]

Actually got this working...

data test2;
    set Test1;
    retain mstr;

    if _n_ = 1 then mstr = var1;
    else
        mstr = trim(mstr)||trim(var1);
run;

Gotta love SAS!

 

[ChrisW75]

Hi Nickdel,
If you're using SAS 9.1, then check out the CATT() and CATX() functions. They do this a little more succinctly.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.