Transcript biostat.mc.vanderbilt.edu

MOON Data File Components
●
Personal Information
●
Entry Evaluation – Kler
●
Patient Questionnaire
●
Physical Exam
●
●
Multi-Dimensional Health Assessment
Patient Knee Injury Questionnaire (R474)
Operative Information
Preliminary Cleaning Tasks
Required for Each MOON Data
Component
●
Converted each MS Access table to SAS
using Proc Import: PROC IMPORT OUT =
EVAL1 DATATABLE =
"moon_evaluation_entry" DBMS =
ACCESS2000 REPLACE; DATABASE =
"H:\Projects\Sports Medicine\11-17-03.MDB";
RUN;
Specific Component Issues
●
Skip patterns
●
Missing, blank, zero, 9, 99, 999.....
–
Not collected?
–
Not entered when it should be?
–
Entered when it shouldn't be?
–
Entered but wrong value?
●
Out of range values
●
Innappropriate values in/out of skip patterns
●
Valid SSNs
Recoding Independent
vs. Dependent Variables
●
●
Independent – variables that are not part of a
skip pattern.
Dependent – variables that are part of a skip
pattern (dependent on the lead variable).
Finalizing File Components
●
●
●
Q/A programs were run on each component
to flag errors.
Changes were hard-coded into the Q/A
program.
Q/A programs were re-run to assure all errors
had been resolved.
Final File Component Q/A
●
●
Frequencies and/or cross-tabs were run on
every variable in each file component.
All values were hand-checked to verify range
validity of file elements compared to Data
Dictionary.
Files Merged into One
●
All files merged by SSN, Surgery Date, and
Knee(L or R).
–
Problematic
●
Not all files had Surgery Date and/or Knee.
–
●
Certain files were pre-merged.
SSNs had been hand-entered and had numerous
mistakes across file components.
–
A renamed SSN was placed on each component.
–
All components merged by SSN.
–
Renamed SSN printed from each component.
–
Hand-checked to spot errors - majority ruled.
Final File Creation
●
Kept only unilateral ACLs for analysis file.
Any individuals not meeting the criteria
defined internally as unilateral ACL
reconstruction were dropped.
–
IF ACL_RECON ≠ 1; /*Form 5*
–
From Kler and physical exams there were
multiple variables which had to be used in
combination to indicate non-unilateral ACL.
Final File
●
●
2002 MOON file consists of 479 subjects
who had unilateral ACL reconstructive
surgery.
Available in beta release pending final
changes.