On a daily basis, I work with a large xlsx data set that I did not author. The data set contains dates for different events (lab reports, death dates, birth dates, etc.) The author will have the word "NULL" for a date observation if the date of an event is unknown. When the data set is brought into SAS, SAS converts the date variables into characters. I need the dates converted back from the character format that SAS has assumed to their actual numeric dates. I am working with SAS 9.4. I converted the NULL values to "." to let SAS know that these are empty, but don't know where to go from here. The code that converts it does not work. It returns dates that are incorrect. *turns null into .*; data work.me; set work.me; if INCIDENT_DATE = "NULL" then INCIDENT_DATE = .; else if CREATEDDT = "NULL" then CREATEDDT = .; else if DEATH_DATE = "NULL" then DEATH_DATE = .; else if DECEDENT_AGE = "NULL" then DECEDENT_AGE = .; else if DECEDENT_DOB = "NULL" then DECEDENT_DOB = .; run; *convert char to date in new variable*; data work.me1; set work.me; incident_date1 = .; incident_date1 = input(incident_date,$15.) format incident_date1 DATETIME16.; run;
... View more