topic Re: time informat, format in SAS Programming

time informat, format

davidnamh — Mon, 31 Mar 2014 03:08:39 GMT

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;

Re: time informat, format

Jagadishkatam — Mon, 31 Mar 2014 03:22:19 GMT

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

Re: time informat, format

ballardw — Mon, 31 Mar 2014 21:30:39 GMT

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;