DATA Step, Macro, Functions and more

Recurring intervals overlapping chosen period?

Reply
New Contributor
Posts: 3

Recurring intervals overlapping chosen period?

[ Edited ]

hi

 

Im looking for an optimized way to decide if a recurring period overlap one or several times with an chosen interval.

 

I have a list of Jobs, with a startdate and a interval(Same for every job).

I want a function that returns startdate and enddate of the interval(s) overlapping the chosen period.

Is there any optimized way to do this with Programming?

 

Lets say:

chosen period: 04feb19 - 18feb19

 

Recurring intervall:

 

Start: 15jan18.

Duration: 13days

Recurr every 6 weeks. until forever..

 

 

Should I use some kind of solve function combined With INTNX? or mod? 

 

Thank you for every input I can get.

 

Regular Contributor
Posts: 195

Re: Recurring intervals overlapping chosen period?

Please post sample data as data-step and include the expected output.

Ask a Question
Discussion stats
  • 1 reply
  • 118 views
  • 2 likes
  • 2 in conversation