Hi,
I have a dataset a and I am left joining b on some keys a.x=b.x and a.y=b.y.
I want SAS to display how many matches happened. Right now it just gives the final number of rows in the final dataset.
select a.*, case when a.x = b.x and a.y = b.y then 1 else 0 end as match
When no match is found, at least one of the b key variables will be missing.
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
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.
Browse our catalog!