Cody’s Data Cleaning Techniques Using SAS® Software

Program to Create the SAS Data Set AE (Adverse Events)

LIBNAME CLEAN "C:\CLEANING";

DATA CLEAN.AE;
   INPUT @1  PATNO   $3.
         @4  DATE_AE MMDDYY10.
         @14 A_EVENT $1.;
   LABEL PATNO   = 'Patient ID'
         DATE_AE = 'Date of AE'
         A_EVENT = 'Adverse Event';
   FORMAT DATE_AE MMDDYY10.;
DATALINES;
00111/21/1998W
00112/13/1998Y
00311/18/1998X
00409/18/1998O
00409/19/1998P
01110/10/1998X
01309/25/1998W
00912/25/1998X
02210/01/1998W
02502/09/1999X
;