[Development of a method for cleaning outpatient data rapidly and generating statistical reports automatically to the analysis of time series on the air pollution and disease].

OBJECTIVE:To develop a method for cleaning the outpatient data rapidly and generating the statistical reports automatically. METHODS:Formulating the cleaning rules according to the data characters, writing programs to clean the individual cases and generate the statistical reports using the SQL language. RESULTS:It could clean the different individual cases rapidly, calculate the daily outpatient visits and generate the statistical reports automatically with high accuracy. CONCLUSION:The method can apply to the data processing of the hospital cases, first aid cases, cause-of-death data and health records. It not only can process large amounts of data flexibly, conveniently and quickly, but also has great practical value. So it is the necessary way to the health risk assessment of air pollution.