DATA Step, Macro, Functions and more

Number of hours worked not weekends

Reply
Occasional Contributor
Posts: 7

Number of hours worked not weekends

Hi

 

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

 

PROC Star
Posts: 554

Re: Number of hours worked not weekends

Occasional Contributor
Posts: 7

Re: Number of hours worked not weekends

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?

Super User
Posts: 17,924

Re: Number of hours worked not weekends

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. 

 

 

 

Super User
Posts: 17,924

Re: Number of hours worked not weekends

Post sample data and expected output. 

Ask a Question
Discussion stats
  • 4 replies
  • 89 views
  • 0 likes
  • 3 in conversation