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;
Are you looking for the MATCHCODE=matchvariablename on the Proc statement?
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.