topic How to read data values into SAS date values (informat) in SAS Programming

How to read data values into SAS date values (informat)

Oleg_L — Fri, 15 Apr 2011 08:44:45 GMT

Hello SAS-users.

I have to read raw data (.csv) into SAS dataset.

Some fields are date values in the form submitted below:

Apr 17 2007 12:00AM,Apr 17 2011 12:00AM
May 28 2007 12:00AM,May 28 2010 12:00AM

I can not find an appropriate informat to read this data into SAS date values.

Thanks in advance for any help.

Re: How to read data values into SAS date values (informat)

Ksharp — Fri, 15 Apr 2011 09:59:34 GMT

[pre]
options datestyle=mdy;
data temp;
infile datalines truncover dlm=' ';
input dt anydtdtm24.;
format dt dateampm24.;
datalines;
Apr 17 2007 12:00AM
Apr 17 2011 12:00AM
May 28 2007 12:00AM
May 28 2010 12:00AM
;
run;
[/pre]

Ksharp

Re: How to read data values into SAS date values (informat)

Oleg_L — Fri, 15 Apr 2011 10:04:49 GMT

Thank you very much.
It works.

Oleg