Dear Team,
I have created one data job and tried to load only duplicate records which is matching the Member Name, Father Name, Mother Name, Spouse Name (included null also), and Age (it can be vary).
One Sample:
Table: 1
Member Name Father Name Mother Name Spouse Name Age
Shakti Rabi Asha Null 25
Sourav Mohan Madhu Rasmita 30
Table2:
Member Name Father Name Mother Name Spouse Name Age
Shaakti Rabbi Asha Mohini 24
Note: In table 1, Member name Shakti and table2 Shaakti both are same.
What I have done described below,
First, I have appended table 1 and Table2
second, then created match code like
MEMBER NAME : Name (Definition), 80% Sensitivity
FATHER NAME : Name (Definition), 80% Sensitivity
Mother Name : Name (Definition), 80% Sensitivity
Age : Text (Definition), 80% Sensitivity.
I Want duplicate data like this:
Member Name Father Name Mother Name Spouse Name Age
Shaakti Rabbi Asha Mohini 24
Unique is:
Member Name Father Name Mother Name Spouse Name Age
Shakti Rabi Asha Null 25
Sourav Mohan Madhu Rasmita 30
But I got this:
Member Name Father Name Mother Name Spouse Name Age
Shakti Rabi Asha Null 25
Sourav Mohan Madhu Rasmita 30
Shaakti Rabbi Asha Mohini 24
Please suggest me How to handle Null values in Match Codes and how to identify Age code it may be +5 or -5 . if actual age is 20 some beneficiaries tried to fraud by age like 21 or 23.
please let me know, if required further details.
Thank You
Shakti
Hi,
Regarding the null/blank values, did you try to use the following options in the Match Code node:
-> Generate null match codes for blank field values
-> Preserve null values?
Regarding the age, it will not work to use a Text type match code definition.
You might want to create a simple function in Expression node to return true/false if the age is in a 10 years range.
Hope this helps.
Audrey
Thank you !!!
I have taken Date of Birth as match code definition. it will works or not ?
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.