This seems to me quite peculiar. When reading datetimes with E8601DT. informat like this: data test;
length date1 8 date2 8 date3 8;
informat date1 e8601dt. date2 e8601dt. date3 e8601dt.;
infile datalines DSD MISSOVER;
input date1 date2 date3;
cards;
2020-09-27 00:00:01.000,,2020-09-27 00:00:00.000
;
run; ...I'm getting a note: NOTE: Invalid data for date2 in line 34 25-25. With the whole dataset I'm eventually getting a WARNING that there were too many of these cases throughout the file. I don't want to supress these warnings, because I do not trust that the source too much. I just would like SAS to acknowledge that the missing value is fine and carry on. Just like it does with other informats, like datetime22. which does not seem to have any issues with missing values: data test;
length date1 8 date2 8 date3 8;
informat date1 datetime22. date2 datetime22. date3 datetime22.;
infile datalines DSD MISSOVER;
input date1 date2 date3;
cards;
09sep2020 00:00:01.000,,09sep2020 00:00:00.000
;
run; Do you have any suggestions? (SAS version: 9.4_M6)
... View more