Cody’s Data Cleaning Techniques Using SAS® Software

Program to Create the SAS Data Set PATIENTS

*-----------------------------------------------------------------*
| PROGRAM NAME: PATIENTS.SAS IN C:\CLEANING                       |
| PURPOSE: TO CREATE A SAS DATA SET CALLED PATIENTS               |
| DATE: MAY 29, 1998                                              |
*-----------------------------------------------------------------*;
LIBNAME CLEAN "C:\CLEANING";

DATA CLEAN.PATIENTS;
   INFILE "C:\CLEANING\PATIENTS.TXT" PAD;
   INPUT @1  PATNO    $3.
         @4  GENDER   $1.
         @5  VISIT    MMDDYY10.
         @15 HR       3.
         @18 SBP      3.
         @21 DBP      3.
         @24 DX       $3.
         @27 AE       $1.;

   LABEL PATNO   = "Patient Number"
         GENDER  = "Gender"
         VISIT   = "Visit Date"
         HR      = "Heart Rate"
         SBP     = "Systolic Blood Pressure"
         DBP     = "Diastolic Blood Pressure"
         DX      = "Diagnosis Code"
         AE      = "Adverse Event?";

   FORMAT VISIT MMDDYY10.;

RUN;