Converting time HH:MM:SS when over 24 hours

[DME790]

Hi All,

I am currently working on time based metrics which give me results of over 24 hours and I want to show the result in HH:MM:SS.

EVENT_MEASURE_VAL is currently in seconds and I convert it by using the format  TIME. which gives me HH:MM .

How can I format it to show HH:MM:SS

Proc Summary data=work.NotReady;
	By WEEK_END_DT;
	VAR EVENT_MEASURE_VAL event_cnt;
Output out=work.notreadyROllUp (DROP=_FREQ_ _TYPE_) SUM=;
RUN;

Data work.notreadyrollupHH;
	Set work.notreadyrollup;
Format event_measure_val time.;
RUN;

Current output

WEEK_END_DT               EVENT_MEASURE_VAL            event_cnt
2017-04-02                                    368100                              651
2017-04-09                                 38908198                        29673
2017-04-16                                38843039                         23754
2017-04-23                                31642259                         20220
2017-04-30                                 29456216                     19358
2017-05-07                              8114040                          14610
2017-05-14                            7851055                            14183

Required Output

WEEK_END_DT     EVENT_MEASURE_VAL       event_cnt
2017-04-02             102:15:00                                    651
2017-04-09            10807:49:38                                29673
2017-04-16            10789:43:39                               23754
2017-04-23            8789:30:59                                20220

Regards

Dean

[PGStats · Accepted solution]

Just give enough space to your time format:

data test;
input WEEK_END_DT :yymmdd10. EVENT_MEASURE_VAL event_cnt;
format WEEK_END_DT yymmdd10. EVENT_MEASURE_VAL time20.;
datalines;
2017-04-02 368100 651
2017-04-09 38908198 29673
2017-04-16 38843039 23754
2017-04-23 31642259 20220
2017-04-30 29456216 19358
2017-05-07 8114040 14610
2017-05-14 7851055 14183
;

proc print data=test noobs; run;

[DME790]

Thanks PG,

I need to stop overthinking SAS.

Cheers

Dean