# Re: st: Ritesh's Inquiry

 From Royce Barondes To statalist@hsphsun2.harvard.edu Subject Re: st: Ritesh's Inquiry Date Sat, 05 Jul 2003 15:36:33 -0500

1. Create a new variable "score_total" (for the entire population or, using "by", the individual community) comprising the sum of all the scores (within the population or community).
2. Generate newvar equal to (score_total-score)/(n-1)

Royce Barondes

At 11:47 AM 7/5/2003 -0700, you wrote:

Dear statalisters,

Lets say i have a list of 10 individuals and 10 scores. For each individual
I would like to compute a new variable that is the average of the other 9
scores. Any ideas on how that can be done?

The data for the example look like this:

id    score    newvar
1    10
2    13
3    12
4    19
5    21
6     9
.
.
.
10    15

The next problem I am having difficulty with is that these 10 individuals
are nested within a community and there are, lets say, 5 communities in
total with 10 individual is each for total N of 50.  I would like to compute
the new variable, where the value for a particular individual is the average
of the scores for the other 9 people in the community where they reside. So
I would like to repeat the procedure separately for each community.

Any help is greatly appreciated,

Ritesh

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Royce de R. Barondes
Associate Professor of Law
203 Hulston Hall
University of Missouri-Columbia School of Law
Columbia, MO 65211
tel: (573) 882-1109
home: www.legal-environment.com
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

• References:
• st:
• From: "Ritesh Mistry" <riteshm@ucla.edu>