Hi all,
I have a variable Time, but its attributes is character. The example is
12/09/2016 05:15:00 AM
12/21/2016 05:23:00 AM
10/27/2016 08:35:00 AM
How can I convert this character to date and time, and still in one column? Since I have AM or PM there, is it possible?
Thanks,
Chen
Assuming that it is mdy date, then:
data want; txt="12/09/2016 05:15:00 AM"; dt=input(txt,mdyampm24.); format dt datetime.; run;
Assuming that it is mdy date, then:
data want; txt="12/09/2016 05:15:00 AM"; dt=input(txt,mdyampm24.); format dt datetime.; run;
Hi RW9,
That really works!!!
Thanks so much for your help!
Chen
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.