BookmarkSubscribeRSS Feed
Number7
Calcite | Level 5

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.

 

1 REPLY 1
error_prone
Barite | Level 11

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1001 views
  • 2 likes
  • 2 in conversation