Some essentials of data cleaning: hints and tips

Felicity Clemens ()
Additional contact information
Felicity Clemens: London School of Hygiene and Tropical Medicine

United Kingdom Stata Users' Group Meetings 2005 from Stata Users Group

Abstract: The cleaning and verification process of many different types of datasets often involves considering similar problems. This presentation will give a very brief simple overview of three useful processes and their associated Stata commands: 1. Finding, counting and removing duplicated data and other multiple entries; 2. Summing individual-level entries to give an overall score per individual - when to treat missing data as 0; 3. Recap of merging data and uses of the merge command The presentation will outline the difficulties that are frequently encountered in these three situations and show how they can be addressed using the common Stata commands of count, rsum, sum and merge/append respectively.

Date: 2005-03-03
References: Add references at CitEc
Citations:

Downloads: (external link)
http://repec.org/usug2005/Clemens-datacleaning_SUG_may05.zip presentation files (application/zip)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:boc:usug05:13

Access Statistics for this paper

More papers in United Kingdom Stata Users' Group Meetings 2005 from Stata Users Group Contact information at EDIRC.
Bibliographic data for series maintained by Christopher F Baum ().