Appreciate your help
What do you consider an address match? Do you use variables PV_addr1 or PV_addr2 or SRVC_addr, or some combination of these?
combination of PV_addr1,PV_addr2,City,ST match with SRVC_addr
Thanks
Thank you. From now on, it would be helpful if you stated important information like this with your original question, instead of not stating it.
Also, from now on, please provide data not as screen captures, but as working SAS data step code (examples and instructions)
Please explain how 10894 apparently is a match since it is not in your output data set, I don't see it, srvc_addr contains STE while pv_addr1 or pv_addr2 contain SUITE, these do not match
I understand, will make sure going forward.
For 10894 , if at all it is possible to consider PV_addr1, City and ST in comparison with SRVC_addr
or else it can be reported in output dataset.
Thank you
Seems like you might want some "fuzzy matching", maybe. See https://blogs.sas.com/content/sgf/2021/09/21/fuzzy-matching/
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: