Converting time HH:MM:SS when over 24 hours

DME790 — Mon, 09 Oct 2017 02:30:42 GMT

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

Re: Converting time HH:MM:SS when over 24 hours

PGStats — Mon, 09 Oct 2017 03:07:18 GMT

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;

Re: Converting time HH:MM:SS when over 24 hours

DME790 — Mon, 09 Oct 2017 03:19:34 GMT

Thanks PG,

I need to stop overthinking SAS.

Cheers

Dean

topic Re: Converting time HH:MM:SS when over 24 hours in SAS Enterprise Guide

Converting time HH:MM:SS when over 24 hours

Re: Converting time HH:MM:SS when over 24 hours

Re: Converting time HH:MM:SS when over 24 hours