PROC DQMATCH

[alwaz_searching]

Hi,

I am getting below error while running PROC DQMATCH to match the records with 2 variables and eventually remove the duplicates based on the clustered records.

ERROR: DF_ERROR_INVALID_NAME.

Could you please help me to see what is causing this error?

Thanks,

Jainee

[Kurt_Bremser]

Always post the whole log of a step, so we can see the message in context.

Use the {i} button for posting logs, so that all the formatting is kept.

[alwaz_searching]

NOTE: There were 5 observations read from the data set WORK.ONE.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      

39         proc dqmatch data= work.one  out= fuzzed matchcode=match_cd cluster=clustergrp locale='ENUSA';;
40         criteria   MATCHDEF='CMP' var= company;
41         criteria    MATCHDEF='ADD' var=address ;
42         run;

ERROR: DF_ERROR_INVALID_NAME
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.FUZZED may be incomplete.  When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.FUZZED was not replaced because this step was stopped.
NOTE: PROCEDURE DQMATCH used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

[Kurt_Bremser]

Could it be that the values you supply in the criteria statements do not match the respective entries in the locale?

The examples use full words (ie "Address") and not abbreviations.

[alwaz_searching]

I used the full text earlier and later tried the abbreviations. No luck. I got the same error.

[ShayneGrant]

The error DF_ERROR_INVALID_NAME means that the supplied definition name for the MATCHDEF parameter is not valid for the given QKB and locale that you are using.  To learn which match definitions are available for your given QKB and locale, you can use the macro '%dqputloc;'  This macro will output the names of all the definitions for each definition type.  Be sure to look at the MATCH DEFINITION(S) section of the output to find an appropriate match definition name to specify for the MATCHDEF parameter within each criteria statement.