If you are looking at a probabilistic match I recommend CDC supplied Link Plus available at https://www.cdc.gov/cancer/npcr/tools/registryplus/lp.htm
The software is free to download and the documentation is there. You do export files to text but the software doesn't require the columns in the text files to have the same names as you can link a field named "LastName" to "FamilyName" or similar.
This will use name, and if you have other useful information like address, phone numbers and such, to provide a probability of match.
Otherwise you need to very clearly describe just what you mean by the "0 to 100".
Functions like COMPGED, COMPLEV and SPEDIS will provide different measures of similarity as well.
@hellohere wrote:
How to compare Name (LAST, MIDDLE, FIRST NAME) with a single function/MACRO?!
Better with return of an index (like 0 to 100)...
... View more