Hi,
I have been able to see Exact definition available through Match Code Node in Data Flux Management Studio. It has given me good results which is what I wanted.
I was able to open QKB and investigate/Test available definitions like Name, Address etc. Unfortunately, I was unable to see the Exact definition in the QKB.
I would like to see what actions are taken to generate a particular match code.
Could anyone please point me to that definition?
Thanks,
Rama
Ahh. I understand now. There isn't really an Exact definition in the QKB. Here is the explanation from the DM Studio User Guide Match Codes Node documentation.
If you specify the Exact value in the drop-down menu, however, a matchcode definition from the QKB is not supplied. Instead, a matchcode is generated that applies UPCASE processing and removes any whitespace from the input string.
Sorry, but I need more information.
Thanks for responding to my query.
1. No, I am using Exact definition. I used as it is available in Match codes node in Data Flux Management Studio.(attached the snapshot of job).
2. I am using English Australia(ENAUS) locale.
3. Exact definition( not sure this answers your question) I have attached the snapshot of the QKB opened in the English Australia locale.
As shown below Name Match definition snapshot, I was able to test ,check results at each step.
I would like to see the similar steps involved in creating match code using Exact definition.
Ahh. I understand now. There isn't really an Exact definition in the QKB. Here is the explanation from the DM Studio User Guide Match Codes Node documentation.
If you specify the Exact value in the drop-down menu, however, a matchcode definition from the QKB is not supplied. Instead, a matchcode is generated that applies UPCASE processing and removes any whitespace from the input string.
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.