DATA Step, Macro, Functions and more

time informat, format

Reply
Occasional Contributor
Posts: 17

time informat, format

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;

Trusted Advisor
Posts: 1,137

Re: time informat, format

Posted in reply to davidnamh

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

Thanks,
Jag
Super User
Posts: 11,343

Re: time informat, format

Posted in reply to davidnamh

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;

Ask a Question
Discussion stats
  • 2 replies
  • 266 views
  • 0 likes
  • 3 in conversation