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,
what is the error?
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
Use the cats() function
Richard in NZ
Thanks, RichardinOz. greatly it worked for me. Here's how I used cats() function
Account1_2 = cats(Account1, Account2);
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.