topic Re: match Code Issue in SAS Data Management Studio in SAS Data Management

match Code Issue in SAS Data Management Studio

Shakti_Sourav — Wed, 27 Jul 2022 07:48:43 GMT

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

Re: match Code Issue in SAS Data Management Studio

audrey — Mon, 08 Aug 2022 16:26:51 GMT

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

Re: match Code Issue in SAS Data Management Studio

Shakti_Sourav — Tue, 09 Aug 2022 13:12:56 GMT

Thank you !!!

I have taken Date of Birth as match code definition. it will works or not ?

Re: match Code Issue in SAS Data Management Studio

VincentRejany — Thu, 08 Sep 2022 21:06:06 GMT

The match code definition for Date is explained here : https://support.sas.com/documentation/onlinedoc/qkb/32/QKBCI32/Help/qkb-help.html#qkbci-engbr/qkbci-engbr.html#Match

Re: match Code Issue in SAS Data Management Studio

RacheLGomez123 — Mon, 21 Nov 2022 07:46:20 GMT

First you need to add match codes to your database lookup table (the one that the SQL Lookup node references). Create name match codes and insert them into this table. Then when you are testing with the external data provider node, add a match code node for the name (using the same definition and sensitivity as you used in appending match codes to your lookup table.). When you are testing perform the SQL lookup on the match codes and not on the exact names and the following results will return Mike = Michael; MIKE = Michael; mike = MICHAEL.

Regards,
Rachel Gomez