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.
Please post sample data as data-step and include the expected output.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.