topic Re: datetime informat - help in SAS Programming

datetime informat - help

moorsd — Mon, 01 Aug 2016 16:23:52 GMT

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

25 July 2016 11:43:20

into a numeric datetime:

thanks

David

Re: datetime informat - help

ballardw — Mon, 01 Aug 2016 16:30:05 GMT

Are the months always the full text, ie December ?

Re: datetime informat - help

ballardw — Mon, 01 Aug 2016 16:44:43 GMT

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;

Re: datetime informat - help

Ksharp — Tue, 02 Aug 2016 03:59:28 GMT


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

Re: datetime informat - help

Ksharp — Tue, 02 Aug 2016 04:13:49 GMT

ANYDTDTM. Powerful.

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

Re: datetime informat - help

ballardw — Tue, 02 Aug 2016 16:20:17 GMT

@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.

Re: datetime informat - help

Ksharp — Wed, 03 Aug 2016 03:02:22 GMT

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

Re: datetime informat - help

moorsd — Mon, 05 Sep 2016 20:23:46 GMT

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.