topic Help!: Identifying Overlapping Date Ranges in New SAS User

Help!: Identifying Overlapping Date Ranges

ChinusGomes — Sat, 19 Oct 2019 06:43:29 GMT

Hi!

I would like some help. I have had no luck in resolving my issue after searching and attempting various iteration of codes for the last three days.

I am trying to write code that would identify and flag any date ranges that overlap with one another. In addition to identifying data range overlap, I am looking to see if there is any overlap in if the person completed the project (yes or no). Attached is a photo of my issue. Thank you for your help!

Re: Help!: Identifying Overlapping Date Ranges

ed_sas_member — Sat, 19 Oct 2019 07:37:50 GMT

Hi @ChinusGomes ,

There is not attachment

Could you please try to load it another time?

Thanks

Re: Help!: Identifying Overlapping Date Ranges

Patrick — Sun, 20 Oct 2019 08:08:27 GMT

Please provide representative sample data (created via a working SAS data step posted into a code window using the running man icon). Then show us the desired result based on the sample data.

Posting an picture is much less helpful as it doesn't give us data to play with and to test the code we propose as solution.

...and if you post sample data with your actual variable name then you've got a good chance that you'll receive solution code which you can directly use with little or no change.