topic Is there a way to show 13:00 - 15:00 (hh:mm - hh:mm) = - 02:00 in SAS Programming

Is there a way to show 13:00 - 15:00 (hh:mm - hh:mm) = - 02:00

phoenix31 — Tue, 17 Sep 2019 19:13:46 GMT

I am trying to take the difference between the current time and a scheduled time which are in HH:MM format (I used TOD5.2 to convert them) and see negative hours.

Please let me know if more information is needed.

Thank you.

Re: Is there a way to show 13:00 - 15:00 (hh:mm - hh:mm) = - 02:00

novinosrin — Tue, 17 Sep 2019 19:18:11 GMT

Hi @phoenix31

Do you mean this?


data w;
t1='13:00't;
t2='15:00't;
dif=intck('hour',t2,t1);
run;

Re: Is there a way to show 13:00 - 15:00 (hh:mm - hh:mm) = - 02:00

novinosrin — Tue, 17 Sep 2019 20:13:53 GMT

Or perhaps, are you looking for picture format?



proc format;
   picture hr (default=6)
 low -  -1      =   '99:99' (prefix='-' mult=100)
  1  - high     =  '99:99' ( mult=100);
  ;

data want;
t1='13:00't;
t2='15:00't;
dif=intck('hour',t2,t1);
format dif hr. t time5.;
run;

Re: Is there a way to show 13:00 - 15:00 (hh:mm - hh:mm) = - 02:00

phoenix31 — Wed, 18 Sep 2019 16:26:23 GMT

Thank you for the update. The code you provided works when both values are in numeric format.

data want;
t1='13:00't;
t2='15:00't;
dif=intck('hour',t2,t1);
run;

My fields are in hh:mm format and if converted to numeric then the years, months ,days and seconds since 1960.

I am using the below code but when the hours are negative my values are not right.

data work.demo_1;
set work.demo_base;
format dif tod5.2;
dif='Time1'n - 'Time2'n;
run;

Re: Is there a way to show 13:00 - 15:00 (hh:mm - hh:mm) = - 02:00

Tom — Wed, 18 Sep 2019 16:38:25 GMT

Why would you store time values with years included?

Do you have DATETIME values instead?

Even so the difference between two datetime values is still going to be a number of seconds. But it could be many days worth of seconds.

Did you want extract just the time part from the datetime value and compare those? If so use the TIMEPART() function to extract just the time since midnight from your time since 1960 values.