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);
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.