The Link King
Record Linkage and Consolidation Software
The Link King v7.1.22 with AutoUpdate for SAS v9
Last program update: 5/9/16


Installation Wizard requires administrator privileges on your workstation.

Wait !  Is The Link King right for you ?  
UPDATE LOG:
5/9/16
Corrected minor bug in the #block_and_eval.sas code in the Version 8 Patch Files

4/29/16
First download and install The Link King using the installer, then download the Version 8
Patch Files, extract the files from the zip and copy/replace in the Link King program
directory.

  • Enhanced (more elegant and comprehensive) algorithm to identify complicated swapping of
    name fields (e.g., first name reported in last name field and last name reported in middle
    name field etc.)  For your review, a dataset is created in the work directory
    (swapped_name) that contains examples of complex name field swapping where all fields
    are involved (i.e., the first, middle, and last name are all involved in the field swapping).   

    Improvements in less complicated name field swapping are also realized.  I am very pleased
    with this modification.

  • Global incorporated of bigram evaluation of name similarity.  Generally this results in a
    boost for the name similarity score submitted to the probabilistic algorithm and impacts a
    relatively small number of record pairs.  For your review, a dataset (Bigram_boost) is
    created in the work directory that contains name pairs where bigram similarity resulted in a
    score boost (if any were found)

  • Revised handling of middle initial matches.  While reviewing record-pairs in the process of
    incorporating the above changes into the process, I identified scenarios related to middle
    initial matches where I felt the scoring for probabilistic evaluation was low.  I made a few
    revisions to the scoring algorithm used in the probabilistic calculation.  



9/30/12
Fixed user identified linkage bug which - in their linkage of over 2,000,000 records - resulted in
the inappropriate exclusion of 36 records. It was a rare scenario involving records very sparsely
populated with client information.

6/23/12
SAS 9.3 changed the output destination to HTML from LISTING.  This causes a lot of
uninformative output to pop-up in the HTML output window. Added code to change output
destination to LISTING at startup so that commands such as "ods listing close" function as
intended.

4/25/12
The last upgrade integrated the 64-bit and 32-bit into a single installation program.  A oversight in
that integration caused some of The Link Kings color highlighting feature to become inoperable.  
This update corrects that issue.

3/9/12
Misc enhancements to interface and accuracy. None critical.

32 Bit and 64 Bit versions integrated into installer.

Autoupdate active again.
Additional Downloads:
The Link King v6.5 for Unix (SASv9)
Link King User Manual v5.2.4
SAMHSA Monograph zip file
Original SAMHSA SAS Code
Link King Screensaver
SAS Double Metaphone Macro
Copyright Camelot Consulting 2004
10-minute Link King Demo Video
The Link King 6.3.43 for SASv8
User Manual Addendum for V6.0
SHORTCUT ERROR SOLUTION

If launching The Link King with the shortcut produces the following error:

ARM: Extension Load Failure

check to make sure the "target" property of the shortcut is pointing to the appropriate SAS.exe
location. To identify that location, right click on you SAS icon, select properties, and use the
target in The Link King shortcut.

To get enable the shortcut:
1. Go to the directory where you installed The Link King
2. Rename undup_frames_64bit.sas7bcat (or _32bit) to undup_frames.sas7bcat
3.The path to SAS.exe in the Link King shortcut should be the same as the path to SAS.exe in
your regular SAS shortcut.
4. The path to sasv9.cfg  in the file LK_config.cfg (in the Link King directory) should be the same
as the path to sasv9.cfg in the target property of your SAS shortcut.
5. If found in the file LK_config.cfg (in the Link King directory), rename
undup_frames_64bit.sas7bcat (or _32bit) to undup_frames.sas7bcat.  

If you cannot get the shortcut to work.  You can launch The Link King by

1. Go to the directory where you installed The Link King
2. Rename undup_frames_64bit.sas7bcat (or _32bit) to undup_frames.sas7bcat
3. Launch SAS
4. Open a program editor
5. Run the following from the program editor.

libname undup "<directory containing The Link King's program files>";
dm 'Af c=undup.undup_frames.program_setup_new.frame;log;icon;explorer;icon;awsmaximize';

or

libname undup "<directory containing The Link King's program files>";
dm 'Af c=undup.undup_frames.intro.frame';
32 & 64 bit Installer
Version 8 Patch Files