How to convert string to time?

[caveman529]

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~~

[Kurt_Bremser · Accepted solution]

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;

[pradeepalankar]

Hi ,

Use  time_numeric=input(time,hhmmss6.);

this should read your time.