Solved
Contributor
Posts: 48

# datetime informat - help

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

25 July 2016 11:43:20

into a numeric datetime:

thanks

David

Accepted Solutions
Solution
‎09-05-2016 04:22 PM
Super User
Posts: 13,584

## Re: datetime informat - help

``````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;``````

All Replies
Super User
Posts: 13,584

## Re: datetime informat - help

Are the months always the full text, ie December ?

Solution
‎09-05-2016 04:22 PM
Super User
Posts: 13,584

## Re: datetime informat - help

``````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;``````
Contributor
Posts: 48

## Re: datetime informat - help

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.
Super User
Posts: 10,788

## Re: datetime informat - help

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

```
Super User
Posts: 10,788

## Re: datetime informat - help

```ANYDTDTM. Powerful.

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

```
Super User
Posts: 13,584

## Re: datetime informat - help

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.

Super User
Posts: 10,788

## Re: datetime informat - help

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

```
☑ This topic is solved.