Solved: Need to convert character to date and time

echoli · Posted 03-10-2017 10:04 AM

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 · Posted 03-10-2017 10:12 AM

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;

RW9 · Posted 03-10-2017 10:12 AM

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 · Posted 03-13-2017 10:15 AM

Hi RW9,

That really works!!!

Thanks so much for your help!

Chen

Need to convert character to date and time