Data Cleaning Techniques
Business Knowledge Series course
This course teaches you how to detect errors in raw data source files as well as showing you how to identify and correct errors in character and numeric SAS data. You will learn a variety of techniques for detecting problems with more complex data structures, such as data sets requiring multiple observations per subject, or requiring entries for a single subject across multiple data sets. More than simply teaching techniques for detecting and fixing data errors, this is also an excellent SAS programming course. Novice and veteran SAS programmers alike will garner new and valuable programming tips and tricks.
Knowledge of the SAS macro language is not a prerequisite, but you will learn to run macros that perform a variety of data cleaning functions. As an example, the AUTO_OUTLIERS macro automatically reports on outliers in numeric data using a concept called "trimmed statistics."
The class closes with a demonstration of an innovative process that leverages integrity constraints and audit trails to detect and programmatically clean dirty data before it even gets into your analysis data set. After class, you'll have access to every program and macro used during class, as well as a personal copy of Cody's Data Cleaning Techniques, Second Edition.
Learn how to
Who should attendSAS programmers, analysts, and researchers
Before attending this course, you should have knowledge and experience at the level of the SAS Programming 1: Essentials course. However, some of the programs discussed in the course use more advanced techniques such as FIRST. and LAST. temporary variables and macro variables. Any SAS programming techniques that are beyond the SAS Programming 1: Essentials level are explained thoroughly in the course.
This course addresses Base SAS, SAS/STAT software.
|Dates||Location||Time||Language||Fee||Add to Cart|
|24-25 APR 2014||New York, NY - Seventh Avenue||9:00-5:00 EDT||English||1650 USD / 3.4 EPTO|
|09-10 JUN 2014||Chicago, IL||9:00-5:00 CDT||English||1650 USD / 3.4 EPTO|
|24-25 SEP 2014||San Francisco, CA||9:00-5:00 PDT||English||1650 USD / 3.4 EPTO|
|13-14 OCT 2014||Cary, NC||9:00-5:00 EDT||English||1650 USD / 3.4 EPTO|
|06-07 NOV 2014||Austin, TX||9:00-5:00 CST||English||1650 USD / 3.4 EPTO|