Knowledge and Data Management White Papers
Using PROC FORMAT for Data Validation and Clean-Up
Overview The purpose of this paper is to illustrate the use of PROC FORMAT with the CNTLIN= option to help in the process of data validation and "Cleaning". Along the way, various methods of transposing data are also demonstrated as well as some other ways of using PROC FORMAT. The example used here are based on a real research study in which medication data had been collected on a large number of nursing home residents, but because of many misspellings, abstraction of inappropriate items and the need to combine many drugs into broad categories for analysis, substantial cleaning was needed before the data could be reported or used in statistical analyses.
| Publisher | SAS Institute | File Format | |
|---|---|---|---|
| Date Published | May 2007 | ||
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 2 out of 4 users found this white paper useful
White Paper RSS
Download
