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