topic Comparing date intervals of similar observations, linked by an ID within same dataset in SAS Programming

Comparing date intervals of similar observations, linked by an ID within same dataset

x2PSx — Fri, 16 Mar 2018 19:13:14 GMT

Hello,

I have one dataset with 12992 observations. I have (half) 6496 different IDs, so 6496 pairs of observations. What I want to do is to compare date intervals within each pair to make sure they don't overlap eachother for the same ID. The dates variables are DATE9. format and informat.

So basically 3 variables: ID, DATE_BEGIN, DATE_END. I am not sure how to proceed with this.

Thank you

Re: Comparing date intervals of similar observations, linked by an ID within same dataset

Reeza — Fri, 16 Mar 2018 19:19:10 GMT

1. Sort your data so that its consecutive ids

2. Use LAG() to get the previous values

3. Check for overlap

@x2PSx wrote:

Hello,

I have one dataset with 12992 observations. I have (half) 6496 different IDs, so 6496 pairs of observations. What I want to do is to compare date intervals within each pair to make sure they don't overlap eachother for the same ID. The dates variables are DATE9. format and informat.

So basically 3 variables: ID, DATE_BEGIN, DATE_END. I am not sure how to proceed with this.

Thank you

Re: Comparing date intervals of similar observations, linked by an ID within same dataset

x2PSx — Fri, 16 Mar 2018 19:51:01 GMT

I just did, thank you!