Date:         Thu, 17 Jan 2008 18:38:52 -0800
Reply-To:     egrogan <erinlgrogan@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         egrogan <erinlgrogan@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Using lags to identify multiple observations per year>
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hello all,
I am working with a large administrative dataset of 2 million +
records. I am trying to determine how many individuals have multiple
observations per year (individuals are identified with an ID number
and may appear several times per year based on different budget
codes).

I've used lags in STATA in the past to identify multiple instances of
the same individual, but I'm not sure how to go about this in SAS.

So, what I'd like to do is find out:
1. How many individuals have multiple observations per year?
2. Of the individuals with multiple observations per year, how many
had multiple job titles in the same year?

Does it make sense to try to use lags here, and can anyone explain how
SAS handles this?

Any thoughts on these questions would be appreciated.