The Link King
Record Linkage and Consolidation Software
The Link King v6.5 with AutoUpdate for SAS v9
Last program update: 5/28/10
NEW! Download v6.51 SAS v9

Windows 64 bit user ?

Installation Wizard requires administrator privileges on your workstation.

Wait !  Is The Link King right for you ?  
Check back for program updates or send
us your e-mail address to be informed of
updates:
UPDATE LOG:
5/28/10
Fixed bug described below.

5/23/10
Important ! A bug has been uncovered in v6.5.  It only impacts "updates to a master listing"
(not simple linkage jobs). A fix (v6.51) will be posted soon along.  The fix will correct the
problem moving forward.  The only way to resolve the issue retroactively is to re-link the data
using an archive of the master listing created prior to linkage using v6.5.

Essentially, the bug may have resulted in incorrect assignment of “CORE / non-CORE” status
(see user manual for information about the utility of this assignment) to a small portion of
records.  Specifically, some CORE records may have been incorrectly assigned as non-
CORE.  The bug WILL NOT incorrectly assign non-CORE records to CORE status.  Because
non-CORE records are not used to establish new linkages, subsequent linkage jobs would miss
some links.  The best estimate we can give of the impact of the problem (which will vary on
the characteristics of the user’s data) is the following :  After using v6.5 to maintain a master
listing of over 700,000 records for 3-months and then linking that master listing to 5,000,000
records from another data system, the bug resulted in a failure to link a little less that 2% of
the records that should have been linked.

Once again;

The bug only impacts "updates to a master listing".

We recommend that re-linking the data using an archive of the master listing created prior to
linkage using v6.5.

3/18/10
v6.5, added
new linkage editing features.

1/8/10 Minor bug fix.

10/16/09 Added conservative algorithm to allow linkage of records containing only fn or
ln as long as dob and ssn are present.  Misc. data processing enhancements.

9/19/09 Incremental enhancement to accuracy (when SSNs are present)

6/24/09 Relatively minor bug fix resulting in an Incremental enhancement to accuracy

6/11/09
The 5/23 update did not fix the bug.  This one does.

5/23/09
Fixed bug of no importance to linkage process.

12/18/08
Incremental enhancement to accuracy.  Fixed bug in the "Restore" feature.

11/17/08
Unix/Linux Download only: Necessary program file was inadvertently omitted from the
Unix/Linux download.  Omission corrected.

11/8/08
If first and middle names are in the same field (separated by a space), The Link King
will now parse them into 2 fields (first and middle) during the Block Prep stage.  

Updated the "Batch Link King Code Generator" to be compatible with changes made
in The Link King to take advantage of new features in SAS 9.2.

10/8/08
Tinkering of no immediate importance.

8/18/08
Incremental improvement to accuracy.

8/5/08 Launch v6.4.  

Added hashing option for Blocking and Deterministic Evaluation steps for users
running SAS v9.2.  Depending on a variety of factors, the hashing algorithm may
reduce blocking time.

User can specify multiple datasets from which The Link King will extract records for
linked individuals and attach the Link King generated uniqueid to extracted records.

SAS v8 no longer specifically supported in v6.4.  New modifications may not be
compatible.

Note: With the release of SAS 9.2, SAS has created yet another warning message
which – in the context of this application – can be ignored.  Specifically, the message:

    WARNING: Multiple lengths were specified for the variable {var name}
    by input data set(s). This may cause truncation of data.

will appear whenever The Link King truncates the length of a data field to be no longer
than the longest value in the field.

6/13/08
Efficiency improvement in implementation of the Jaro-Winkler algorithm.

5/30/08
Incremental improvement to accuracy and efficiency.

2/29/08
Fixed bug. New Jaro-Winkler algorithm (added 2/12/08) would crash when no middle
name was present (or MI only).

2/12/08
Resource utilization efficiency enhancement when blocking level set to "High".

Integrated Jaro-Winkler string comparison algorithm (with prefix and long-string
adjustments) into the algorithm.
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
Download v6.4 SAS v9