Events
« March 2010 »
SunMonTueWedThuFriSat
123456
78910111213
14151617181920
21222324252627
28293031
Archives Search

Search UC-UTCC Archives
 

Related Websites
The Townsend Thai Project

The University of Chicago

University of the Thai Chamber of Commerce

The Interuniversity Consortium for Political and Social Research (ICPSR)

Dataverse Network Project

Printer-friendly versionSend to friendPDF version

5 Steps for Automated Cleansing and Data QC

Cleansing Process

  1. Check the variables that we need to do cleansing whether there is any relation to another variable or not.
  2. When we have the variables from first step, we will search for the possible error.
  3. We will bring those errors to build the data quality rules to mark the missing.
  4. Transfer the data quality rules that we built into script in order to let the program SAS replace the values from 3rd step
  5. Examine the accuracy of the cleaned data with our data quality rules.
Our Services
UC-UTCC Data Depository TSpower (Visualization System)SET Smart Enterprise