topic Re: Number of hours worked not weekends in SAS Programming

Number of hours worked not weekends

SimonJ — Thu, 20 Apr 2017 09:49:32 GMT

I am working in enyterprise guide 9.1 i am trying to identify how i can calulate the time between to given dates not including weekends and going forward bank holidays.

I lknow i can use the INTCK function this works great for the number of hours elapsed but does not consider weekends, i know there is a weekday element but this does not work its like i need workhours can anyone help?

Thanks

Simon

Re: Number of hours worked not weekends

PeterClemmensen — Thu, 20 Apr 2017 09:51:42 GMT

check this out

http://blogs.sas.com/content/sasdummy/2011/05/09/calculating-the-number-of-working-days-between-two-dates/

Re: Number of hours worked not weekends

SimonJ — Thu, 20 Apr 2017 10:04:00 GMT

Hey thanks for this i think that would help when i get to the bank holiday stage, What about hours this is where i am struggling with at the moment?

Re: Number of hours worked not weekends

Reeza — Thu, 20 Apr 2017 10:42:34 GMT

It's essentially the same as the blog post, but INTCK can take an hour parameter and you should have datetime variables not date variables.

Re: Number of hours worked not weekends

Reeza — Thu, 20 Apr 2017 10:43:39 GMT

Post sample data and expected output.