Desktop productivity for business analysts and programmers

Converting time HH:MM:SS when over 24 hours

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 84
Accepted Solution

Converting time HH:MM:SS when over 24 hours

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:MMSmiley FrustratedS.

 

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:MMSmiley FrustratedS

 

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


Accepted Solutions
Solution
‎10-08-2017 11:18 PM
Respected Advisor
Posts: 4,973

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

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;



PG

View solution in original post


All Replies
Solution
‎10-08-2017 11:18 PM
Respected Advisor
Posts: 4,973

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

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;



PG
Frequent Contributor
Posts: 84

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

Thanks PG,

 

I need to stop overthinking SAS.

 

Cheers

 

Dean

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 172 views
  • 0 likes
  • 2 in conversation