We are analyzing data in the following format. Our question is,
how can we identify IDs where the difference between any 2 sequential values for "Level" is more than 2?
We have looked through SAS resources and, as relatively new programmers, can't figure this out.
Thank you!!
ID Date Level
1 01/01/2000 1
1 01/02/2000
1 01/05/2000 3
1 01/05/2010
2 01/06/2010 5
2 02/12/2005 6