5 Steps for Automated Cleansing and Data QC

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.