topic Re: To Add Flags for the cluster rules passed by the records in PROC DQMATCH in SAS Programming

To Add Flags for the cluster rules passed by the records in PROC DQMATCH

DevBanerjee — Mon, 15 Jul 2024 13:07:56 GMT

How do I create an Identifying Flag which will tell me using which rule combination it is creating the ClusterId's?

Using following code I'm creating the Match Codes:

data MC_tbl;
set sample_data;
A_MC85=dqmatch(Name,'Name',85);
B_MC80=dqmatch(Address,'Address',85);
C_MC80=dqmatch(Company,'Company',80);
run;

while using following code I'm doing the clustering process:
proc dqmatch data=Work.MC_tbl out=Work.Cluster cluster=Clusterid ;

criteria condition=1 var=A_MC85 exact;
criteria condition=1 var=B_MC80 exact;

criteria condition=2 var=A_MC85 exact;
criteria condition=2 var=C_MC80 exact;
quit;

Re: To Add Flags for the cluster rules passed by the records in PROC DQMATCH

ballardw — Mon, 15 Jul 2024 14:35:31 GMT

Are you looking for the MATCHCODE=matchvariablename on the Proc statement?

Re: To Add Flags for the cluster rules passed by the records in PROC DQMATCH

DevBanerjee — Tue, 16 Jul 2024 07:35:10 GMT

No, I just want to add an flag variable so that it will tell me that this record passing this rule combination to create the clusterID for further analysis.