How to reads the date time fields like 3/5/2017 12:00:00 AM from CSV file.?
Thanks in advance
Are you looking for something like
data input;
format date datetime.;
input date mdyampm21.2;
datalines;
3/5/2017 12:00:00 AM
;
run;
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.
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.
data input;
format date datetime.;
input date anydtdtm32.;
datalines;
3/5/2017 12:00:00 AM
;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.