Data cleaning is a necessary evil... Or is it? Many techniques exist that prevent data errors at data gathering and/or at data input. The use of these techniques eliminates or minimizes the errors that actually get into the computer files. Other techniques include proper form design, data monitoring, double keying, and hash totals. This paper examines these error-prevention techniques through examples and where applicable, it includes SAS code.
Did you find this white paper useful?
7 out of 14 users found this white paper useful
Related white papers
Delivering information you can trust
The amount of data businesses generate can be overwhelming.Now add different types of data and multiple departments and silos the information is stored across. You quickly understand the scramble to...
Oracle ONE: Technology and Solutions Catalogue for Small, Medium and Growing Businesses
Download the latest February 2008 issue of Oracle ONE.This white paper looks into how Oracle Database 11g Standard Edition ONE can help you protect sensitive business data effectively and reduce...
Ensuring Data Protection for Growing Businesses
In this white paper, we look at how SMBs often progress through the IT adoption cycle and consider some of the operational and security challenges they face in aligning their...
Oracle Database 10g Standard Edition One: Meeting the Needs of Small and Medium Sized Businesses
Databases have become key in enabling businesses to efficiently manage their data assets and to effectively use information to better understand their businesses. This document considers the question of what is needed...
Algroup Lawson Mardon Selects PECAS Vision
Algroup lawson mardon, a leading global supplier of packaging to the tobacco industry, was most interested in a system that would supply traceability, or full tracking of materials throughout the...
Getting Started with Master Data Management
Master data management forms part of an overall enterprise governance program that aims to establish trusted data throughout the enterprise. This white paper from Mike Ferguson of Intelligent Business Strategies...
Data Governance for Master Data Management and Beyond
There is growing interest on behalf of both data management professionals and senior business managers to understand the motivations, mechanics, and benefits of instituting data governance within an organization. This...
