BookmarkSubscribeRSS Feed
AliMN
Calcite | Level 5

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,

4 REPLIES 4
data_null__
Jade | Level 19

what is the error?

AliMN
Calcite | Level 5

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
Quartz | Level 8

Use the cats() function

Richard in NZ


AliMN
Calcite | Level 5

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

Account1_2 = cats(Account1, Account2);

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 2172 views
  • 0 likes
  • 3 in conversation