concatenate two character columns into one column

[AliMN]

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,

[data_null__]

what is the error?

[AliMN]

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

[RichardinOz]

Use the cats() function

Richard in NZ

[AliMN]

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

Account1_2 = cats(Account1, Account2);