proc dqmatch

sameer112217 — Thu, 30 May 2019 10:56:06 GMT

proc dqmatch data = sample out = cluster_out (compress=yes) matchcode=match_cd
cluster = cluster_id;
criteria condition = 1 var = FULL_NAME matchdef='Name India' sensitivity=85;
criteria condition = 1 var = ENGINENO_5 matchdef='Text' sensitivity=95;
criteria condition = 1 var = CHASSISNO_5 matchdef='Text' sensitivity=95;

When I am running this code, the second var engineno_5 qne chassino_5 has blank values and in sas dqmatch it is grouping in the same cluster if there is a match with just one condition of full_name. I need a code where it has to match all the three conditions to group it in the same cluster. In Dataflax the blank or null value is not considered.

Re: proc dqmatch

ballardw — Fri, 31 May 2019 16:11:35 GMT

@sameer112217 wrote:

proc dqmatch data = sample out = cluster_out (compress=yes) matchcode=match_cd
cluster = cluster_id;
criteria condition = 1 var = FULL_NAME matchdef='Name India' sensitivity=85;
criteria condition = 1 var = ENGINENO_5 matchdef='Text' sensitivity=95;
criteria condition = 1 var = CHASSISNO_5 matchdef='Text' sensitivity=95;

When I am running this code, the second var engineno_5 qne chassino_5 has blank values and in sas dqmatch it is grouping in the same cluster if there is a match with just one condition of full_name. I need a code where it has to match all the three conditions to group it in the same cluster. In Dataflax the blank or null value is not considered.

I don't have any actual experience with this procedure but from the documentation on the CRITERIA statement

EXACT | MATCHDEF=

assigns a cluster number.

EXACT

assigns a cluster number based on an exact character match between values.

Restriction If you specify the EXACT= option, you cannot specify the MATCHDEF= option, the MATCHCODE= option, or the SENSITIVITY= option.

MATCHDEF=match-definition

specifies the match-definition that is used to create the match code for the specified variable.

Restrictions The match-definition must exist in the locale that is specified in the LOCALE= option of the DQMATCH procedure.

If you specify the MATCHDEF= option, you cannot specify the EXACT option, the MATCHCODE= option, or the SENSITIVITY option.

(some emphasis added)

it appears that you need to rethink the condtions as MATCHDEF and SENSITIVITY apparently are incompatible. I would check your log for any notes about one or more of the options being ignored or similar.

Restrictions	The match-definition must exist in the locale that is specified in the LOCALE= option of the DQMATCH procedure.
	If you specify the MATCHDEF= option, you cannot specify the EXACT option, the MATCHCODE= option, or the SENSITIVITY option.

topic Re: proc dqmatch in SAS Data Management

proc dqmatch

Re: proc dqmatch

EXACT | MATCHDEF=

EXACT

MATCHDEF=match-definition