BookmarkSubscribeRSS Feed
Shakti_Sourav
Quartz | Level 8

Dear Team,

Please suggest, what is Name / Name With Combinations / Name with Extensions ? 

If there is a Name column having First Name, Middle Name and also Sur name then which one should take ? 

I have attached one screenshot for your reference.

 

Shakti_Sourav_1-1653386680374.png

 

1 REPLY 1
audrey
SAS Employee

Hi,

 

These 3 definitions exist in the English (India) locale for the current version of the QKB.

They are documented here:

https://support.sas.com/documentation/onlinedoc/qkb/33/QKBCI33/Help/qkb-help.html#qkbci-enind/qkbci-...

 

Name definition is the most basic. I wouldn't use it for long strings that have more tokens than just a first and family names.

Name with Extensions can handle much longer input strings, with Extensions, Middle Names, etc. This is the one I would use for what you describe.

 

The Name with Combinations is a different type of Matching definition: Combination-based match definitions create multiple match codes for a single input string by manipulating the tokens of the input string with token combination rules.

 

See more information here:

https://support.sas.com/documentation/onlinedoc/qkb/33/QKBCI33/Help/Content/qkb-generaldoc/qkb-mtchd...

 

Hope this helps.

 

Thanks,
Audrey

www.sas.comsupport.sas.com
SAS®... THE POWER TO KNOW®

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to connect to databases in SAS Viya

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.

Discussion stats
  • 1 reply
  • 822 views
  • 0 likes
  • 2 in conversation