Hello! I'm trying to read in a date variable from a text file. The dates are formatted like this: 1/1/2000 1/15/2000 12/1/2000 12/12/2000 There are no leading zeroes on the month or day pieces of the date. I've tried using the ANYDTDTE informat, but it is only recognizing the dates with two digit days, and any date with a one digit day is showing up as missing. I've also tried a few other date informats, but I think since the lengths of the dates in the text file are not consistent, they are not working either. Here is my code: Data Sample; Infile 'File_1.txt' dlm='|' firstobs=2 truncover; input ID $ date ANYDTDTE.; format date mmddyy10. run; Any suggestions?
... View more
