concatenate two character columns into one column

Reply
Contributor
Posts: 49

concatenate two character columns into one column

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,

Respected Advisor
Posts: 3,777

Re: concatenate two character columns into one column

what is the error?

Contributor
Posts: 49

Re: concatenate two character columns into one column

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

Super Contributor
Posts: 644

Re: concatenate two character columns into one column

Use the cats() function

Richard in NZ


Contributor
Posts: 49

Re: concatenate two character columns into one column

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

Account1_2 = cats(Account1, Account2);

Ask a Question
Discussion stats
  • 4 replies
  • 242 views
  • 0 likes
  • 3 in conversation