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.

2004-05-14T11:53:47