Combine Datasets using Inexact Character Variables in SAS

[Patrick]

As said I'm not very experienced with DataFlux.

- "Data Joining node": I've just looked it up Using Reference Data Manager Domain Items in a Job . You must chose "full" as join type - and the variables you're selecting to be used for the join must represent a key.

- Match codes allow you to create a key for a set of variables (eg. first-, middle-, last name). Standardisation allows you to cleanse your data, eg. variations of the same company name converted to the same name. You can use either for matching depending on what suits your case better.

- The SAS "DQ...." functions allow you to use DataFlux functionality out of SAS in a data step. So the "DQ..." functions use DataFlux as well.