topic concatenate two character columns into one column in SAS Programming

concatenate two character columns into one column

AliMN — Mon, 09 Dec 2013 23:09:51 GMT

Hello,

My dataset (ABC) contain the following columns: account1, account2 and I want to combine (concatenate) account1 and account2 columns and create another column called account1_2. Here is the how the dataset (ABC) is look like now:

account1	account2
1200	3000

My final result (wanted) should be look like:

account1	account2	account1_2
1200	3000	12003000

Here is my code but for some reason, I’m getting an error message.

Data wanted;

Set ABC;

length Account1_2 $10;

Account1_2 = catx('', Account1, Account2);

run;

Any help is appreciated,

Re: concatenate two character columns into one column

data_null__ — Mon, 09 Dec 2013 23:16:51 GMT

what is the error?

Re: concatenate two character columns into one column

AliMN — Mon, 09 Dec 2013 23:35:45 GMT

I got the answer I was expecting but my only problem now is, I want to get rid off the space between the two numbers under account1_2 column to make it 12003000: here's my result now:

account1	account2	account1_2
1200	3000	1200 3000

Thanks in advance

Re: concatenate two character columns into one column

RichardinOz — Mon, 09 Dec 2013 23:57:16 GMT

Use the cats() function

Richard in NZ

Re: concatenate two character columns into one column

AliMN — Tue, 10 Dec 2013 15:00:07 GMT

Thanks, RichardinOz. greatly it worked for me. Here's how I used cats() function

Account1_2 = cats(Account1, Account2);