A Simple Interface for defining, programming and managing SAS edit checks

If SAS ® is still widely used for data cleaning, EDC technology has however deeply changed the schedule of data cleaning management. The validation plan should now be defined at an early stage of the project, while programs must be ready to send off-line queries as soon as the data collection has started, in conformity with first-stage specifications. During the course of the trial, it is not rare to modify the validation plan, and this along with the subsequent programming changes, should be managed as well. In this context we have designed an optimized SAS workflow interfaced with a simple web-based application, allowing the simultaneous definition of edit checks and the automatic generation of the corresponding SAS source codes. The validation plan and underlying programming are then entirely managed through this user friendly web application offering an integrated solution for the fast, efficient and traceable implementation of edit checks.