topic Re: How to convert date string datetime format in SAS Procedures

How to convert date string datetime format

pp2014 — Wed, 04 Feb 2015 14:16:59 GMT

I have date string = "20150109103704" How do I convert it to 09JAN2015:10:37:04

RW9 — Wed, 04 Feb 2015 14:51:31 GMT

Hi,

The DHMS() function is probably easiest:

data want;

orig="20150109103704";

datet=dhms(input(substr(orig,1,8),yymmdd8.),input(substr(orig,9,2),2.),input(substr(orig,11,2),2.),input(substr(orig,13,2),2.));

format datet datetime.;

run;

pp2014 — Wed, 04 Feb 2015 15:01:18 GMT

Thanks..