SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Find Matching records using SAS DQ

Reply
Frequent Contributor
Posts: 77

Find Matching records using SAS DQ

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..

 

 

 

 

 

Respected Advisor
Posts: 4,674

Re: Find Matching records using SAS DQ

[ Edited ]
Posted in reply to india2016

@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.

Ask a Question
Discussion stats
  • 1 reply
  • 133 views
  • 1 like
  • 2 in conversation