topic Re: How to convert string to time? in SAS Programming

How to convert string to time?

caveman529 — Mon, 03 Mar 2014 06:35:45 GMT

The attached dataset has time in 24 hour format, see below:

000257

000341

000419

000433

000437

000451

002538

002719

002903

003029

003135

003141

So 133846 indicates 1 pm 38 minutes 46 seconds. But the value is in string. How could I convert the TIME string into SAS time? I used the following code:

data WANG;

set HAVE;

time_numeric = input(time, time5.);

run;

But it doesn't seem to work. SAS reports:

NOTE: Invalid argument to function INPUT at line 24 column 8.

time=000257 timej=. _ERROR_=1 _N_=11

NOTE: Invalid argument to function INPUT at line 24 column 8.

time=000341 timej=. _ERROR_=1 _N_=12

Could you guys help me~~

Re: How to convert string to time?

Kurt_Bremser — Mon, 03 Mar 2014 08:02:39 GMT

Do this:

data wang;

set have;

format time_numeric time8.;

time_numeric = input(substr(time,1,2) !! ':' !! substr(time,3,2) !! ':' !! substr(time,5,2),time8.);

run;

Re: How to convert string to time?

pradeepalankar — Mon, 03 Mar 2014 10:40:13 GMT

Hi ,

Use time_numeric=input(time,hhmmss6.);

this should read your time.