topic Re: matching variables in dataflux in SAS Data Management

matching variables in dataflux

margautz — Wed, 17 Aug 2016 07:13:21 GMT

Hello All,

I have Dataflux Management Studio 2.4.

Is it possible to create a match between full names and initials? I mean, may I create a match between "First Investment Date" and "FID"?

Thank you for your time and help.

Best,

Margherita

Re: matching variables in dataflux

RonAgresta — Thu, 18 Aug 2016 10:26:45 GMT

Hi Margherita,

Yes, you can do this in DataFlux Data Management Studio 2.4. First you should identify the match definition you want to use, probably the "Organization" match definition for the locale/language of the data you want to match. Then use the Customize component to open the match definition so you can see the different steps of the algorithm. One of these steps will be a standardization step where data is transformed to find matches like you describe. Find the appropriate standardization definition (most organization match definitions will have a standardization "scheme" with a few of these kinds of transformations already), open it and add the variations you would like to have match. Save the scheme changes. If you had a job open while you were making these changes, close it and reopen it to reload the Quality Knowledge Base that contains the updated definiton.

Ron

Re: matching variables in dataflux

margautz — Fri, 19 Aug 2016 14:51:49 GMT

Hello Ron,

thank you for your reply.

I am a dummy in DataFlux 🙂 so... is this the Customize component ?

If not, where is the Customize component to open and modify the match definition?

Thank you again and I am sorry for the trivial question.

Best,

Margherita

Re: matching variables in dataflux

RonAgresta — Fri, 19 Aug 2016 15:03:12 GMT

Yes, that's it. Use Customize to open the Quality Knowledge Base (QKB) and navigate to the match definition you want to use. Once you open the match definition, you can see the various files that it employs to match data. The product documentation describes how to use the Customize application. Consider making a copy of the match definition first using Customize before you start making changes.

Ron