BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
NCEU
Calcite | Level 5

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!

1 ACCEPTED SOLUTION
2 REPLIES 2
ballardw
Super User

There are a largish number of Informats available as there are many different ways that people/systems will write dates.
DATETIME, ANYDTDTE or ANYDTDETM would also have worked with the appropriate width specified with the understanding that you could have datetime variable or a date variable.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 4669 views
  • 5 likes
  • 3 in conversation