manuall cleaning of names.
(Entered 04-Jan-2007)
get file='C:\temp\PLASC_2003_YR8_edit.sav' .
rename var pfulname=fulnameold.
String pfulname(A45).
exe.
compute pfulname=lower(fulnameold).
* Identify Duplicate Cases.
SORT CASES BY ypdob(A) pfulname(A).
AGGREGATE OUTFILE = 'C:\temp\tempdata.sav'
/presorted
/break = ypdob pfulname
/duplicatecount = N.
Match files /file=* /table='C:\temp\tempdata.sav' /by ypdob pfulname.
sort cases by duplicatecount (D).
***Result: about 650 duplicates by upn in the admin file. Cut and save these
into an excel file.
sort cases ypdob(A) pfulname(A).
save outfile='C:\temp\PLASC_2003_YR8_matching3.sav' .
save outfile='I:\WORKDOCS\I9688\LYSPE to NPD
matching\PLASC_2003_YR8_matching3.sav' .
(Entered 02-Jan-2007)
get file='C:\temp\PLASC_2004_YR9_edit.sav' .
* Identify Duplicate Cases BY ypdob(A) pfulname(A).
***Result: about 470 duplicates by upn in the admin file. Cut and save these
rename var leaestab=leaestab2.
save outfile='C:\temp\PLASC_2004_YR9_matching4.sav' .
matching\PLASC_2004_YR9_matching4.sav' .
***
get file='C:\temp\KS2_2001_YR6_edit.sav' .
***Result: about 5074 duplicates by ypdob pfulname in the admin file. Cut and
save these into an excel file.
save outfile='C:\temp\KS2_2001_YR6_matching6.sav' .
matching\KS2_2001_YR6_matching6.sav' .
'***file prepared for matching with cases where UPN is missing by ypdob and
pfulname.'
***var pfulname changed to contain only lower cases.
get file='C:\temp\PLASC_2004_YR9_edit.sav'.
***Result: 473 duplicates by upn in the admin file. Cut and save these '
'into an excel file.'
save outfile='C:\temp\PLASC_2004_YR9_matching9.sav' .
matching\PLASC_2003_YR8_matching9.sav' .
get file='C:\temp\PLASC_2005_YR10_edit.sav'.
***Result: 4481 duplicates by upn in the admin file. Cut and save these '
temp.
select if duplicatecount gt 1.
save outfile='C:\temp\duplicates2005.sav'.
save outfile='C:\temp\PLASC_2005_YR10_matching10.sav' .
matching\PLASC_2005_YR10_matching10.sav' .
***file prepared for matching with cases where UPN is missing by ypdob and
get file='C:\temp\PLASC_Census_2006_Yr11_edit.sav'.
***Result: 4364 duplicates by upn in the admin file. Cut and save these '
save outfile='C:\temp\duplicates2006.sav'.
save outfile='C:\temp\PLASC_Census_2006_Yr11_matching11.sav' .
matching\PLASC_Census_2006_Yr11_matching11.sav' .
get file='C:\temp\KS4_2006_YR11_edit.sav' .
***Result: about 820 duplicates by ypdob pfulname in the admin file. Cut and
save outfile='C:\temp\ks4_2006_YR11_matching4.sav' .
matching\ks4_2006_YR11_matching4.sav' .