I have two datasets. One our own and the other a clients. I need to match them. However in our dataset we use Account_Number and the client uses BANKACCOUNT. I need match what accounts are in both datasets to produce a matching dataset and a non-matching dataset for Reconciliation purposes. How can this be done? Thanks
Below is my code which does not work
data Match No_Match; Merge Dataset1 Dataset2; by ACCOUNT_NUMBER BANKACCOUNT; if ina and inb then output Match; else output No_Match; run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.