Hello all, I have a data set with a bunch of people in it, each of whom have different claims at different times. I need a code to return all claims which are billed for three consecutive months for that particular person. For example, I have the following: Person Claim Month Year A 1 Mar 2013 A 2 Apr 2013 A 3 May 2013 A 4 Aug 2014 B 5 Sep 2012 B 6 Oct 2012 B 7 Oct 2012 C 8 Dec 2013 I basically just need to it return the 'Claim' values of 1, 2, and 3 since person A billed in three consecutive months. How would I do this? Much appreciated.
... View more