Hi, I would like some help in selecting the last date of the first series of consecutive observations (Sas enterprise 6.1). Currently my (large) dataset is comprised of dates (numeric) per ID. Example: OBS ID Date 1 1 20150316 2 1 20150317 3 1 20150318 4 1 20150326 5 1 20150327 6 1 20150328 7 1 20150329 8 1 20150330 9 1 20150331 10 2 20150601 11 2 20150602 12 2 20150603 13 2 20150624 14 2 20150625 15 2 20150907 16 2 20150908 17 3 20150127 18 3 20150128 19 3 20150129 20 3 20150130 21 3 20150131 And would like my output to look like: OBS ID Date 1 1 20150318 2 2 20150603 3 3 20150131 (dates for obs 3, 12 and 21 ) I know how to select the first obs per ID and last obs per ID but not this.. Hopefully someone can help me! Thanks
... View more