<>
webuse grunfeld,clear
egen sumrest = total(time), by(company)
egen n = count(time), by(company)
g meanrest = (sumrest - time) / (n - 1)
meanrest is the average of the values not including the current value
for each company. Replace 'time' with 'invest' to get something more
meaningful (so to speak).
Kit Baum | Boston College Economics and DIW Berlin | http://ideas.repec.org/e/pba1.html
An Introduction to Stata Programming | http://www.stata-press.com/books/isp.html
An Introduction to Modern Econometrics Using Stata | http://www.stata-press.com/books/imeus.html
*
* 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/