time informat, format

[davidnamh]

Hi, I have time in HHMMSSS and would like to informat and  format it with (eg 12:23:123) in SAS dataset. 

I used time7. for informat, but returns with "." in the SAS dataset.. Could you please help me how to do that ? Thanks you so much.

data have;

input hhmmsss;

datalines;

1223123

0403267

;

run;

[Jagadishkatam]

I used the picture format to get the result.

proc format;

picture times (default=10) low-high="99:99:990";

run;

data have;

input hhmmsss;

time=put(hhmmsss,times.);

datalines;

1223123

0403267

;

run;

Thanks,

Jag

[ballardw]

And you are having problems because your data as written is indicating more that 60 seconds to a minute.

You may want to get the fractional seconds using a different informat if want an actual time value:

data have;
informat hhmmsss b8601tm7.1;
input hhmmsss  ;
format hhmmsss   time12.1;
datalines;
1223123
0403267
;

run;