Hi all, I have dataset with two variables (ID and DAY). Data are numerical SAS formats. I would like to put out the records for ID where: The first day should be <50 and the last day should be >100. All the consecutive days (for each ID) should be >15. So that, if in any interval between consecutive days that was less than 15 days the second one should be removed. In finally, i want to keep the IDs that have more than 2 valid observations (Day) within them. For example: Input is like this: ID Day 1 26 1 38 1 107 2 73 2 105 2 156 3 48 3 89 3 116 3 127 4 13 4 88 4 154 5 32 5 98 5 106 6 12 6 79 6 109 7 27 7 39 7 132 7 169 Output should be like this: ID Day 3 48 3 89 3 116 4 13 4 88 4 154 6 12 6 79 6 109 7 27 7 132 7 169 Is there a way to to come up the output I want? Thank you ... View more