prg1c08 - 1 Chapter 8: Validating and Cleaning Data 8.1...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 Chapter 8: Validating and Cleaning Data 8.1 Introduction to Validating and Cleaning Data 8.2 Examining Data Errors When Reading Raw Data Files 8.3 Validating Data with the PRINT and FREQ Procedures 8.4 Validating Data with the MEANS and UNIVARIATE Procedures 8.5 Cleaning Invalid Data 2 Chapter 8: Validating and Cleaning Data 8.1 Introduction to Validating and Cleaning Data 8.1 Introduction to Validating and Cleaning Data 8.2 Examining Data Errors When Reading Raw Data Files 8.3 Validating Data with the PRINT and FREQ Procedures 8.4 Validating Data with the MEANS and UNIVARIATE Procedures 8.5 Cleaning Invalid Data 3 Objectives Define data errors in a raw data file. Identify procedures for validating data. Identify techniques for cleaning data. Define the business scenario that will be used with validating and cleaning data. 3 4 Business Scenario A delimited raw data file containing information on Orion Star non-sales employees from Australia and the United States needs to be read to create a data set. Requirements of non-sales employee data: Employee_ID , Salary , Birth_Date , and Hire_Date must be numeric variables. First , Last , Gender , Job_Title , and Country must be character variables. 4 5 6 8.01 Quiz What problems will SAS have reading the numeric data Salary and Hire_Date ? 6 Partial nonsales.csv 120101,Patrick,Lu,M, 163040 ,Director,AU,18AUG1976, 01JUL2003 120104,Kareen,Billington,F, 46230 ,Administration Manager,au,11MAY1954, 01JAN1981 120105,Liz,Povey,F, 27110 ,Secretary I,AU,21DEC1974, 01MAY1999 120106,John,Hornsey,M, unknown ,Office Assistant II,AU,23DEC1944, 01JAN1974 120107,Sherie,Sheedy,F, 30475 ,Office Assistant III,AU,01FEB1978, 21JAN1953 120108,Gladys,Gromek,F, 27660 ,Warehouse Assistant II,AU,23FEB1984, 01AUG2006 120108,Gabriele,Baker,F, 26495 ,Warehouse Assistant I,AU,15DEC1986, 01OCT2006 120110,Dennis,Entwisle,M, 28615 ,Warehouse Assistant III,AU,20NOV1949, 01NOV1979 120111,Ubaldo,Spillane,M, 26895 ,Security Guard II,AU,23JUL1949, 99NOV1978 120112,Ellis,Glattback,F, 26550 , ,AU,17FEB1969, 01JUL1990 120113,Riu,Horsey,F, 26870 ,Security Guard II,AU,10MAY1944, 01JAN1974 120114,Jeannette,Buddery,G, 31285 ,Security Manager,AU,08FEB1944, 01JAN1974 120115,Hugh,Nichollas,M, 2650 ,Service Assistant I,AU,08MAY1984, 01AUG2005 .,Austen,Ralston,M, 29250 ,Service Assistant II,AU,13JUN1959, 01FEB1980 120117,Bill,Mccleary,M, 31670 ,Cabinet Maker III,AU,11SEP1964, 01APR1986 7 8.01 Quiz Correct Answer What problems will SAS have reading the numeric data Salary and Hire_Date ? 7 Partial nonsales.csv 120101,Patrick,Lu,M, 163040 ,Director,AU,18AUG1976, 01JUL2003 120104,Kareen,Billington,F, 46230 ,Administration Manager,au,11MAY1954, 01JAN1981 120105,Liz,Povey,F, 27110 ,Secretary I,AU,21DEC1974, 01MAY1999 120106,John,Hornsey,M, unknown ,Office Assistant II,AU,23DEC1944, 01JAN1974 120107,Sherie,Sheedy,F, 30475 ,Office Assistant III,AU,01FEB1978, 21JAN1953 120108,Gladys,Gromek,F, 27660 ,Warehouse Assistant II,AU,23FEB1984,...
View Full Document

This note was uploaded on 02/20/2012 for the course STAT 506 taught by Professor Staff during the Fall '08 term at Purdue University-West Lafayette.

Page1 / 124

prg1c08 - 1 Chapter 8: Validating and Cleaning Data 8.1...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online