Automated Data Cleaning Linking Data Manager to Study Coordinator: Error Finding by Variable and Error Fixing by Subject
Source: Columbia University
Many researchers using the SAS System software receive data sets with incomplete data or data errors. Data cleaning can become an extremely tedious task for the Coordinators who must return to medical records or Case Report Forms (CRFs) if the data managers list errors by variable. Instead it is easier for Coordinators to clean data when errors are listed by subject across all CRFs. The series of macros encompass a step-by-step process that allow for error searching by variable, while outputting errors by subject.