DQmatch for a given name

[TzufRaifMia]

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

[momo66]

"><momo

[momo66]

<a>momo</a>

[SASKiwi]

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. 

[Patrick]

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?