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);
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.