need help in finding at least one address match by group, if not then report in output dataset

[cm3]

need help in finding at least one address match by group(TaxID NPI), if not then report in output dataset 

Appreciate your help 

[PaigeMiller]

What do you consider an address match? Do you use variables PV_addr1 or PV_addr2 or SRVC_addr, or some combination of these?

[cm3]

combination of PV_addr1,PV_addr2,City,ST  match with  SRVC_addr

Thanks

[PaigeMiller]

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

[cm3]

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 

[PaigeMiller]

Seems like you might want some "fuzzy matching", maybe. See https://blogs.sas.com/content/sgf/2021/09/21/fuzzy-matching/