datetime informat - help

[moorsd]

Would anyone know the best informat to turn the following character value:

25 July 2016 11:43:20

into a numeric datetime:

thanks

David

[ballardw]

Are the months always the full text, ie December ?

[ballardw · Accepted solution]

Here's one example that may help you.

data example;
   x="25 July 2016 11:43:20";
   z= dhms(input(cats( scan(x,1), substr(scan(x,2),1,3) , scan(x,3)),date9.),0,0,input(scan(x,4),time8.));
   format z datetime20.;
run;

[moorsd]

Thanks for the help, and I have to apologise for not getting back to you sooner. I've not been in work for a while so didn't get around to accepting your solution.

[Ksharp]

data example;
   x="25 July 2016 11:43:20  ";
   z=input(translate(strip(x),':',' '),anydtdtm32.);
   format z datetime20.;
run;
proc print;run;

[Ksharp]

ANYDTDTM. Powerful.

data example;
   x="25 July 2016 11:43:20  ";
   z=input(x,anydtdtm32.);
   format z datetime20.;
run;
proc print;run;

[ballardw]

---

@Ksharp wrote:

ANYDTDTM. Powerful.

data example;
   x="25 July 2016 11:43:20  ";
   z=input(x,anydtdtm32.);
   format z datetime20.;
run;
proc print;run;

---

Yields missing value for z in my install (boss still hasn't updated from 9.2). I tried that first thing so wasn't sure whether it would work on others.

[Ksharp]

Ou. Are you still using SAS9.2 . That is almost ten years ago .
I am using UE, it is working for me .