topic DQmatch for a given name in SAS Procedures

DQmatch for a given name

TzufRaifMia — Sun, 12 Nov 2023 09:50:32 GMT

Hey All!

I am trying to use DQMATCH for my DQ project.

My task is to detect some "same" names. A difficult case is a name which is a short for another name.

For example, "Bill Gates" has the same match code as "William Gates", since "Bill" is a short name of "William", and "Gates" is the Family name for both.

But, when I pass only "Bill", "William" to the function, it creates different match codes.

How can I generate same match codes to these 2 names without having the need of passing Family name?

I'm not committed for using 'DQMATCH' so I'll glad to hear any other ideas.

Attached are outputs.

Thanks in advanced,

Tzuf

Re: DQmatch for a given name

momo66 — Sun, 12 Nov 2023 15:19:11 GMT

"><momo

momo

momo66 — Sun, 12 Nov 2023 15:20:28 GMT

Re: DQmatch for a given name

SASKiwi — Sun, 12 Nov 2023 19:14:33 GMT

If you only supply part of a name then DQMATCH will most likely assume BILL and WILLIAM are surnames and so are indeed different. DQMATCH works better the more complete the attribute being matched is in my experience.

Re: DQmatch for a given name

Patrick — Sun, 12 Nov 2023 21:46:55 GMT

It's way too long ago that I have used SAS DQ to really know so just guessing:

What happens if you concatenate a fixed last name (like: Gates) to your variable with a first name only and then use dqmatch() on this string?