Using a DATA Step to Check for Invalid Values
Your next task is to use a DATA step to identify invalid data values and to determine where they occur in the raw data file (by listing the patient number).
This time, DATA step processing is used to identify invalid character values for selected variables. As before, you will check GENDER, DX, and AE. Several different methods are used to identify these values.
First, you can write a simple DATA step that reports invalid data values by using PUT statements in a DATA _NULL_ step. Here is the program.
Program 1-3. Using a DATA _NULL_ Step to Detect Invalid Character Data
DATA _NULL_; INFILE "C:\CLEANING\PATIENTS.TXT" PAD; FILE PRINT; ***Send output to the Output window; TITLE "Listing of Invalid Patient ... |
Get Cody’s Data Cleaning Techniques Using SAS® Software now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
