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
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
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
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.