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

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

cm3 — Thu, 27 Jul 2023 13:28:56 GMT

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

Appreciate your help

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

PaigeMiller — Thu, 27 Jul 2023 13:31:38 GMT

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

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

cm3 — Thu, 27 Jul 2023 13:35:32 GMT

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

Thanks

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

PaigeMiller — Thu, 27 Jul 2023 13:49:18 GMT

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

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

cm3 — Thu, 27 Jul 2023 14:01:51 GMT

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

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

PaigeMiller — Thu, 27 Jul 2023 14:05:47 GMT

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