topic Find Matching records using SAS DQ in SAS Data Management

Find Matching records using SAS DQ

india2016 — Thu, 05 Oct 2017 06:57:14 GMT

Hello everyone,

I am new to SAS DQ Tool. Actually, I am working on two datasets where I got one or two variables which are partially same. So my concern is to match those records and make golden dataset which is used for next process.

suppose I have datasets A and B which have variable as below,

A B

Name Name

Address Postal Address

Phone No. Father's Name

Gender

Variable Name and Addresses can be matched exactly or partially.

How can I get one final dataset using SAS DQ? Which Node should I use and what would logic for getting final result?

Any information link, document or any solution will be appreciated.

Thanks..

Re: Find Matching records using SAS DQ

Patrick — Fri, 06 Oct 2017 09:22:35 GMT

@india2016

I'm not the expert in this so just high level: If you've got the SAS MDM solution which builds on the technology you've got licensed then that's what you should be using: http://support.sas.com/documentation/onlinedoc/mdm/

If you haven't got the MDM solution then your DM Studio gives you still access to the functionality but you will have to build parts on your own. Here the docu link as starting point: https://support.sas.com/documentation/onlinedoc/dfdmstudio/2.7/dmpdmsug/dfUnity.html

If you haven't done so already then I recommend you get the relevant SAS training before trying to use the tool.