Datetime format

[Vasu33]

How to reads the date time fields like 3/5/2017  12:00:00 AM from CSV file.?

Thanks in advance

[RW9]

Use the appropriate informat:

http://support.sas.com/documentation/cdl/en/leforinforref/63324/HTML/default/viewer.htm#p0py1o500c7q...

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a001239776.htm

[GertNissen]

Are you looking for something like

data input;

format date datetime.;

input date mdyampm21.2;

datalines;

3/5/2017 12:00:00 AM

;

run;

[Vasu33]

Thanks very much.

 But i have used MDYAMPM. and it seemed to work fine.

I would like to understand what is the difference between mdyampm21.2; & MDYAMPM.

Am i missing something here?

Thanks again.

[GertNissen]

It will depend on your format, as there are many ways to write date, time etc with or without different details..

Have a look at http://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#p0unvzltcs19...

default if MDYAMPM19.

[Ksharp]

data input;
format date datetime.;
input date anydtdtm32.;
datalines;
3/5/2017 12:00:00 AM
;
run;