Data Quality Management, Data Cleansing, and Discrepancy Reporting
Source: North Carolina State University
Whether ones data comes in the form of SAS datasets or in another form, Data Quality Management and Data Cleansing are a must. With Data Cleansing comes Discrepancy reporting. This paper covers Data Quality Management, Data Cleansing, and Discrepancy reporting techniques applicable to most SAS shops. Data Cleansing is important if the sources are external and especially critical if the data source is from manual input. Whether one is just getting started on a new project or realize more Data Management is necessary for a current project, these areas require proper documentation and planning using best standards. This paper will offer practical approaches to these topics using Base SAS/Macros.