topic Re: SAS - Time difference in hour between two fields excluding weekends in SAS Programming

SAS - Time difference in hour between two fields excluding weekends

phoenix31 — Mon, 31 Dec 2018 16:53:32 GMT

Hello All,

I am trying to calculate the time difference in hours by excluding weekends.

By using the code below to get the difference in hours:

LSC_Time_Diff = intck('hours','Status Time Date'n, 'Current time'n); ------> This gives me the difference in hours but done not exclude weekends.

I know that intck ('Weekday', field1, field2) will exclude weekends however I want to consider the timestamp and see the result in hours.

PS: I do not want business hours. I just want to exclude weekend hours (Sat & Sun = 48 hrs) to be excluded every time i run my code

Please advise and let me know if more information is needed.

Thank you.

Re: SAS - Time difference in hour between two fields excluding weekends

ballardw — Mon, 31 Dec 2018 17:07:19 GMT

@phoenix31 wrote:

Hello All,

I am trying to calculate the time difference in hours by excluding weekends.

By using the code below to get the difference in hours:

LSC_Time_Diff = intck('hours','Status Time Date'n, 'Current time'n); ------> This gives me the difference in hours but done not exclude weekends.

I know that intck ('Weekday', field1, field2) will exclude weekends however I want to consider the timestamp and see the result in hours.

PS: I do not want business hours. I just want to exclude weekend hours (Sat & Sun = 48 hrs) to be excluded every time i run my code

Please advise and let me know if more information is needed.

Thank you.

If you have a fixed known amount, such as 48 hours then subtract that. I suspect you would want a check that the interval actually crossed a weekend though if you are dealing with irregular intervals.

Re: SAS - Time difference in hour between two fields excluding weekends

Kurt_Bremser — Mon, 31 Dec 2018 18:47:34 GMT

Subtract

intck('dtweek','Status Time Date'n, 'Current time'n) * 48