[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
Chao Yawo <yawo1964@yahoo.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: RE: Creating a Non-Self Mean (Score) |

Date |
Tue, 22 Jul 2008 07:32:06 -0700 (PDT) |

Nick, Thanks very much for your latest response. The "count option" worked beautifully. rgds, CY --- On Sun, 7/13/08, Chao Yawo <yawo1964@yahoo.com> wrote: > From: Chao Yawo <yawo1964@yahoo.com> > Subject: Re: st: RE: Creating a Non-Self Mean (Score) > To: statalist@hsphsun2.harvard.edu > Date: Sunday, July 13, 2008, 11:58 AM > Hi, > > Thanks for the suggestions. I was able to create (Sum of > Others - This Value), as suggested, hence I have the > numerator for creating the Mean of Others. However, I am > running into a bit of a problem creating the denominator. > > Here is what my data looks like at the moment: > > Obs Strata SumOthers MeanOthers > > 1 1 3 2 > 2 1 1 > 3 1 2 > 4 2 1 > 5 2 3 > 6 1 3 > > The Mean for observation 1 = ([3+1+2+3]-3 / 4 - 1) = 2. > > That is, to the get the mean of others, I have to divide > the "Sum of Others - This Value" by a > denominator that counts the "number of observations > within each strata - 1". I looked at the Count option, > however, I realized that it saves it output as a scalar, > hence I am unable to get the denominator required. > > I would appreciate any assistance to get around this. > > Thanks in advance -- CY > > > Mean of others = (Sum of all - This value) / (Number in > group - 1) > > > --- On Thu, 7/3/08, Chao Yawo <yawo1964@yahoo.com> > wrote: > > > From: Chao Yawo <yawo1964@yahoo.com> > > Subject: Re: st: RE: Creating a Non-Self Mean (Score) > > To: statalist@hsphsun2.harvard.edu > > Date: Thursday, July 3, 2008, 2:22 PM > > Nick, thanks very much. I will review the documents > and > > get back to the list with any further questions. > > > > I appreciate your assistance. > > > > rgds, CY > > > > > > --- On Thu, 7/3/08, Nick Cox > <n.j.cox@durham.ac.uk> > > wrote: > > > > > From: Nick Cox <n.j.cox@durham.ac.uk> > > > Subject: st: RE: Creating a Non-Self Mean (Score) > > > To: statalist@hsphsun2.harvard.edu > > > Date: Thursday, July 3, 2008, 8:30 AM > > > This is a FAQ. See > > > > > > FAQ . . Creating variables recording prop. of > the > > other > > > members of a > > > group > > > 4/05 How do I create variables > summarizing > > for > > > each > > > individual properties of the > other > > members > > > of a > > > group? > > > > > > > http://www.stata.com/support/faqs/data/members.html > > > > > > The key principle for sums is elementary > > > > > > Sum of others = Sum of all - This value > > > > > > And for means correspondingly > > > > > > Mean of others = (Sum of all - This value) / > (Number > > in > > > group - 1) > > > > > > Other summary measures are more challenging, but > the > > FAQ > > > gives advice. > > > > > > The only obvious complication is that you want to > sum > > > across variables > > > before you summarize across the other members of > this > > > group. That will > > > often be easiest through -egen, rowtotal()-. > > > > > > Nick > > > n.j.cox@durham.ac.uk > > > > > > Chao Yawo > > > > > > > > > I am examining the effect of stigmatizing > attitudes of > > > specific health > > > behaviors, using a demographic health survey > (DHS). > > DHS > > > respondents were > > > required to indicate (by a YES, NO, DONT KNOW) > > whether: > > > > > > (1) whether they would buy a vegetable from a > vendor > > who > > > has HIV, (2) > > > whether they would keep their family member's > HIV > > > infection a secret > > > (3) whether they would be willing to care for a > > relative > > > who is infected > > > with HIV > > > (4) wheether a female teacher infected with HIV > should > > be > > > allowed to > > > continue teaching in school > > > > > > I want to calculate a summary score that reflects > > community > > > attitude > > > (the attitudes of all members of the community on > > these > > > variables --- > > > that is the score must EXCLUDE those of the > > respondent, and > > > INCLUDE > > > those of all others. In some literature, this is > > referred > > > to as > > > non-self mean. > > > > > > Since in the DHS, clusters (V022) are the lowest > level > > from > > > which a > > > sample of households is drawn (i.e. these are > > typically the > > > primary > > > sampling unit), I want a score based on the > responses > > of > > > all people in > > > the same strata (PSU) as the respondent, but > excluding > > the > > > respondent's > > > responses. For example, to compute this score for > an > > > individual A who > > > resides in PSU B, we sum the stigma scores (over > all > > the 4 > > > variables) of > > > all individuals in PSU B, with the exceptoin of > > respondent > > > A. > > > > > > I would be very grateful if you could give me > some > > pointers > > > about how to > > > create this summary score (over all the 4 > variables). > > > > > > regards, C. Y. > > > > > > > > > > > > > > > * > > > * 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/ > > > > > > * > > > * 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/ > > > > > > > > * > > * 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/ > > > > * > * 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/ * * 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/

**References**:**Re: st: RE: Creating a Non-Self Mean (Score)***From:*Chao Yawo <yawo1964@yahoo.com>

- Prev by Date:
**Re: st: IV with missing values** - Next by Date:
**st: Display ValuesLabels and NumericCodes in Tabulate Tables** - Previous by thread:
**RE: st: RE: Creating a Non-Self Mean (Score)** - Next by thread:
**st: Display ValuesLabels and NumericCodes in Tabulate Tables** - Index(es):

© Copyright 1996–2017 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |