topic Need to convert character to date and time in SAS Programming

Need to convert character to date and time

echoli — Fri, 10 Mar 2017 15:04:19 GMT

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

RW9 — Fri, 10 Mar 2017 15:12:05 GMT

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;

echoli — Mon, 13 Mar 2017 14:15:25 GMT

Hi RW9,

That really works!!!

Thanks so much for your help!

Chen