•	National Projections 2004 – 2014
•	Recovery Month
•	National Expenditures 1993-2003
•	Co-Occurring Center for Excellence
•	SAMHSA Grant Awards

	Mission
	Programs
	Publications
	Resources
	Media
	FAQs
	Funding Opportunities

Integrated Medicaid and State Agency Mental Health and Substance Abuse Data Analysis and Technical Assistance

Integrated Data Base Record Linking - SAS Programs for Probabilistic Record Linking

Topic Information
This page highlights programs and information -- developed in creating the IDB -- on linking data from multiple sources. Materials include presentations, a technical report, programming code, and other supporting materials.

The presentations explain record linking concepts and techniques. The first presentation, "Record Linking 101," begins with examples from the IDB project demonstrating improved results using probabilistic linking, then covering basic linking theory, providing the necessary background for applying the IDB linking programs.

The second presentation, "Record Linking 102," builds on the concepts explained in "Record Linking 101" and describes how to implement the IDB record linking programs. It starts with details of how probabilistic linking techniques are used by the IDB programs, and move on to an explanation of how to implement the programs.

Presentations and Other Materials

Record Linking 101 (563 KB)
Introduction to probabilistic record linking concepts and techniques. PowerPoint® presentation, approximately 120 minutes.

Record Linking 102 (370 KB)
Adapting and implementing the IDB probabilistic record linking programs. PowerPoint® presentation, approximately 90 minutes.

Click to download a free copy of the PowerPoint® viewer.

Linking Client Records from Substance Abuse, Mental Health, and Medicaid State Agencies. (173 KB)
This report describes the concepts behind record linking and the specific application of record linking in building databases integrating information of substance abuse and mental health services.

Note: This PDF file requires that Adobe Reader® 6.0 or higher be installed on your computer. To download a FREE copy of the software, click here.

IDB Linking Programs

Overview of IDB Linking Process
Data flow diagram of IDB the linking programs.

Variables (and attributes) used in IDB Linking Programs (8 KB)

Listing of IDB Linking Programs (9 KB)

SAS code for IDB linking programs. (Zip file, 712 KB)

(click here to return to the tools and presentations page)

(click here to return to the Spending, Organization and Financing Treatment Services home page)

For further information, contact the CSAT staff at 240-276-2750.