CLiREN-LMS
Data Cleaning and Preparation in R

Creating Derived Variables

Table 1

30-45 minutes Applied Step 6 of 12
Table

Table 1

6 / 12
Table

Table 1

Derived variableSource variablesRule sourceRisk if poorly defined
Age at enrollmentDate of birth, enrollment dateEligibility criteria or analysis planIncorrect eligibility classification
Length of stayAdmission date, discharge dateProtocol or clinical definitionMisreported secondary outcome
Visit window statusEnrollment date, visit dateSchedule of eventsIncorrect assessment of protocol adherence
BMIWeight, heightClinical measurement guidanceUnit errors or implausible values
Outcome statusMultiple endpoint fieldsEndpoint charter or protocolIncorrect primary endpoint classification