Appendix C. Matching Programs: Crash to License and Death Certificate to License



Program to Match Crashes to Driver License

PROGRAM GEOMATCH
;

DICTA CRASH
DICTB MAST

;

BLOCK1 CHAR LIC_NO LIC_NO

;

MATCH1 ARRAY UNCERT LNAME LNAME 0.9 0.01 700
MATCH1 ARRAY UNCERT FNAME FNAME 0.9 0.01 700
MATCH1 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH1 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH1 CHAR SEX SEX 0.9 0.5

;

BLOCK2 CHAR LN_SDX LN_SDX1
BLOCK2 CHAR FN_SDX FN_SDX1
BLOCK2 CHAR DOB DOB

;

MATCH2 ARRAY UNCERT LNAME LNAME 0.9 0.01 700
MATCH2 ARRAY UNCERT FNAME FNAME 0.9 0.01 700
MATCH2 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH2 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH2 CHAR SEX SEX 0.9 0.5
MATCH2 CNT_DIFF LIC_NO LIC_NO 0.9 0.01 1

;

BLOCK3 CHAR LN_SDX LN_SDX2
BLOCK3 CHAR FN_SDX FN_SDX2
BLOCK3 CHAR DOB DOB

;

MATCH3 ARRAY UNCERT LNAME LNAME 0.9 0.01 700
MATCH3 ARRAY UNCERT FNAME FNAME 0.9 0.01 700
MATCH3 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH3 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH3 CHAR SEX SEX 0.9 0.5
MATCH3 CNT_DIFF LIC_NO LIC_NO 0.9 0.01 1

;

BLOCK4 CHAR LN_SDX LN_SDX3
BLOCK4 CHAR FN_SDX FN_SDX3
BLOCK4 CHAR DOB DOB

;

MATCH4 ARRAY UNCERT LNAME LNAME 0.9 0.01 700
MATCH4 ARRAY UNCERT FNAME FNAME 0.9 0.01 700
MATCH4 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH4 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH4 CHAR SEX SEX 0.9 0.5
MATCH4 CNT_DIFF LIC_NO LIC_NO 0.9 0.01 1

;

BLOCK5 CHAR LN_SDX LN_SDX1
BLOCK5 CHAR FN_SDX FN_SDX1
BLOCK5 CHAR STATE STATE

;

MATCH5 ARRAY UNCERT LNAME LNAME 0.9 0.01 700
MATCH5 ARRAY UNCERT FNAME FNAME 0.9 0.01 700
MATCH5 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH5 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH5 CHAR SEX SEX 0.9 0.5
MATCH5 CNT_DIFF LIC_NO LIC_NO 0.9 0.01 3

;

BLOCK6 CHAR LN_SDX LN_SDX2
BLOCK6 CHAR FN_SDX FN_SDX2
BLOCK6 CHAR STATE STATE

;

MATCH6 ARRAY UNCERT LNAME LNAME 0.9 0.01 700
MATCH6 ARRAY UNCERT FNAME FNAME 0.9 0.01 700
MATCH6 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH6 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH6 CHAR SEX SEX 0.9 0.5
MATCH6 CNT_DIFF LIC_NO LIC_NO 0.9 0.01 3

;

BLOCK7 CHAR LN_SDX LN_SDX3
BLOCK7 CHAR FN_SDX FN_SDX3
BLOCK7 CHAR STATE STATE

;

MATCH7 ARRAY UNCERT LNAME LNAME 0.9 0.01 700
MATCH7 ARRAY UNCERT FNAME FNAME 0.9 0.01 700
MATCH7 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH7 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH7 CHAR SEX SEX 0.9 0.5
MATCH7 CNT_DIFF LIC_NO LIC_NO 0.9 0.01 3

;

BLOCK8 CHAR DOB DOB
BLOCK8 CHAR STATE STATE

;

MATCH8 ARRAY UNCERT LNAME LNAME 0.9 0.01 700
MATCH8 ARRAY UNCERT FNAME FNAME 0.9 0.01 700
MATCH8 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH8 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH8 CHAR SEX SEX 0.9 0.5
MATCH8 CNT_DIFF LIC_NO LIC_NO 0.9 0.01 3

;

CUTOFF1 0 -10 0
CUTOFF2 25 13 25
CUTOFF3 30 20 30
CUTOFF4 40 10 40
CUTOFF5 39 34.5 40
CUTOFF6 40 20 40
CUTOFF7 40 20 40
CUTOFF8 30 23 40

;

Program to Match Death Certificate to Driver License

PROGRAM MATCH

;

DICTA FT

DICTB MAST

;

BLOCK1 CHAR SSN SSN

BLOCK1 CHAR SEX SEX

;

MATCH1 ARRAY UNCERT LNAME_A LNAME_A 0.9 0.01 700
MATCH1 ARRAY UNCERT FNAME_A FNAME_A 0.9 0.01 700
MATCH1 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH1 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH1 CHAR SEX SEX 0.9 0.5
MATCH1 UNCERT CITY CITY 0.9 0.05 700
MATCH1 CHAR STATE STATE 0.9 0.1
MATCH1 CNT_DIFF ZIP ZIP 0.9 0.1 1

;

BLOCK2 CHAR LN_SDX LN_SDX

BLOCK2 CHAR FN_SDX FN_SDX

BLOCK2 CHAR DOB DOB

;

MATCH2 ARRAY UNCERT LNAME_A LNAME_A 0.9 0.01 700
MATCH2 ARRAY UNCERT FNAME_A FNAME_A 0.9 0.01 700
MATCH2 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH2 CNT_DIFF SSN SSN 0.9 0.01 2
MATCH2 CNT_DIFF SSN2 SSN2 0.9 0.01 2
MATCH2 CHAR SEX SEX 0.9 0.5
MATCH2 UNCERT CITY CITY 0.9 0.05 700
MATCH2 CHAR STATE STATE 0.9 0.1
MATCH2 CNT_DIFF ZIP ZIP 0.9 0.1 1

;

BLOCK3 CHAR DOB DOB

BLOCK3 CHAR FN_SDX FN_SDX

BLOCK3 CHAR SEX SEX

;

MATCH3 ARRAY UNCERT LNAME_A LNAME_A 0.9 0.01 700
MATCH3 ARRAY UNCERT FNAME_A FNAME_A 0.9 0.01 700
MATCH3 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH3 CNT_DIFF SSN SSN 0.9 0.01 2
MATCH3 CNT_DIFF SSN2 SSN2 0.9 0.01 2
MATCH3 UNCERT CITY CITY 0.9 0.05 700
MATCH3 CHAR STATE STATE 0.9 0.1
MATCH3 CNT_DIFF ZIP ZIP 0.9 0.1 1

;

BLOCK4 CHAR SSN2 SSN2

;

MATCH4 ARRAY UNCERT LNAME_A LNAME_A 0.9 0.01 700
MATCH4 ARRAY UNCERT FNAME_A FNAME_A 0.9 0.01 700
MATCH4 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH4 CNT_DIFF DOB DOB 0.9 0.01 1
MATCH4 CHAR SEX SEX 0.9 0.5
MATCH4 UNCERT CITY CITY 0.9 0.05 700
MATCH4 CHAR STATE STATE 0.9 0.1
MATCH4 CNT_DIFF ZIP ZIP 0.9 0.1 1

;

BLOCK5 CHAR LN_SDX LN_SDX

BLOCK5 CHAR FN_SDX FN_SDX

;

MATCH5 UNCERT LNAME LNAME 0.9 0.01 700
MATCH5 ARRAY UNCERT FNAME_A FNAME_A 0.9 0.01 700
MATCH5 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH5 CNT_DIFF SSN SSN 0.9 0.01 2
MATCH5 CNT_DIFF SSN2 SSN2 0.9 0.01 2
MATCH5 UNCERT CITY CITY 0.9 0.05 700
MATCH5 CHAR STATE STATE 0.9 0.1
MATCH5 CHAR SEX SEX 0.9 0.5
MATCH5 CNT_DIFF ZIP ZIP 0.9 0.1 1
MATCH5 CNT_DIFF DOB DOB 0.9 0.01 2

;

BLOCK6 CHAR LN_SDX LN_SDX2

BLOCK6 CHAR FN_SDX FN_SDX

;

MATCH6 UNCERT LNAME LNAME2 0.9 0.01 700
MATCH6 ARRAY UNCERT FNAME_A FNAME_A 0.9 0.01 700
MATCH6 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH6 CNT_DIFF SSN SSN 0.9 0.01 2
MATCH6 CNT_DIFF SSN2 SSN2 0.9 0.01 2
MATCH6 UNCERT CITY CITY 0.9 0.05 700
MATCH6 CHAR STATE STATE 0.9 0.1
MATCH6 CHAR SEX SEX 0.9 0.5
MATCH6 CNT_DIFF ZIP ZIP 0.9 0.1 1
MATCH6 CNT_DIFF DOB DOB 0.9 0.01 2

;

BLOCK7 CHAR LN_SDX LN_SDX3

BLOCK7 CHAR FN_SDX FN_SDX

;

MATCH7 UNCERT LNAME LNAME3 0.9 0.01 700
MATCH7 ARRAY UNCERT FNAME_A FNAME_A 0.9 0.01 700
MATCH7 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH7 CNT_DIFF SSN SSN 0.9 0.01 2
MATCH7 CNT_DIFF SSN2 SSN2 0.9 0.01 2
MATCH7 UNCERT CITY CITY 0.9 0.05 700
MATCH7 CHAR STATE STATE 0.9 0.1
MATCH7 CHAR SEX SEX 0.9 0.5
MATCH7 CNT_DIFF ZIP ZIP 0.9 0.1 1
MATCH7 CNT_DIFF DOB DOB 0.9 0.01 2

;

BLOCK8 CHAR LN_SDX LN_SDX

BLOCK8 CHAR FN_SDX FN_SDX

;

MATCH8 ARRAY UNCERT LNAME_A LNAME_A 0.9 0.01 700
MATCH8 ARRAY UNCERT FNAME_A FNAME_A 0.9 0.01 700
MATCH8 ARRAY CHAR MINIT MINIT 0.9 0.1
MATCH8 CNT_DIFF SSN SSN 0.9 0.01 2
MATCH8 CNT_DIFF SSN2 SSN2 0.9 0.01 2
MATCH8 UNCERT CITY CITY 0.9 0.05 700
MATCH8 CHAR STATE STATE 0.9 0.1
MATCH8 CHAR SEX SEX 0.9 0.5
MATCH8 CNT_DIFF ZIP ZIP 0.9 0.1 1
MATCH8 CNT_DIFF DOB DOB 0.9 0.01 2

;

CUTOFF1 10 0 10
CUTOFF2 10 0 10
CUTOFF3 32 10 32
CUTOFF4 10 0 10
CUTOFF5 40 10 40
CUTOFF6 40 10 40
CUTOFF7 40 10 40
CUTOFF8 40 10 40

;

vartype dob critical missingok