I have the following txt file: 130.192.70.235 - - [08/Jun/2008:23:51:32 -0700] "GET /rover.jpg HTTP/1.1" 200 66820 128.32.236.8 - - [08/Jun/2008:23:51:40 -0700] "GET /grooming.html HTTP/1.0" 200 8471 128.32.236.8 - - [08/Jun/2008:23:51:40 -0700] "GET /Icons/brush.gif HTTP/1.0" 200 89 128.32.236.8 - - [08/Jun/2008:23:51:40 -0700] "GET /H_poodle.gif HTTP/1.0" 200 1852 118.171.121.37 - - [08/Jun/2008:23:56:46 -0700] "GET /bath.gif HTTP/1.0" 200 14079 128.123.121.37 - - [09/Jun/2008:00:57:49 -0700] "GET /lobo.gif HTTP/1.0" 200 18312 128.123.121.37 - - [09/Jun/2008:00:57:49 -0700] "GET /statemnt.htm HTTP/1.0" 200 238 128.75.226.8 - - [09/Jun/2008:01:59:40 -0700] "GET /Icons/leash.gif HTTP/1.0" 200 98 Now I want to read in the data, let's focus on the date. The correct solution is: data newdata2; infile 'D:\SAS\Messy Data.txt'; Input @'[' AccessDate Date11. ; run; However, I thought that this is correct: data newdata2; infile 'D:\SAS\Messy Data.txt'; Input @'[' AccessDate DDMMYY10. ; run; I am not sure about the 10, but at least I thought it has to be the DDMMYY format, because in the txt file, the format of the date values is dd/mm/yyyy. But when I use date11., I thought it should be in something like 1jan1961. So why do I have to use date and not ddmmyy? Thanks a lot for your help!
... View more