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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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!