st: Analyzing Multiple Records in Stata

[Erin Mead <emead@jhsph.edu>]

I am sure there is probably an easy way to do this in Stata, but I
cannot figure it out. I am working with a data set in which the
participants were interviewed multiple times (up to 9). Each row of
the data set is for one interview with one participant. So, each
participant has 9 rows, one for each interview. Like so:

id       interview      var1     var2   ...
2            1              5.5      6.9
2            2              3.4      9.0
...

There are only a few variables in the data set. I would like to create
one row for each participant, and each variable be the average of that
variable across the interviews. This isn't a survival analysis (there
are no failures), so I thought stset would be inappropriate. Any
suggestions?

Thanks for your time

Erin
PhD student

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/