Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down at the end of May, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Nick Cox <njcoxstata@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Sum variable over all countries excluding observations from nth country |

Date |
Sat, 1 Sep 2012 17:37:14 +0100 |

Note that this is an FAQ: FAQ . . Creating variables recording prop. of the other members of a group . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . N. J. Cox 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 Nick On Sat, Sep 1, 2012 at 4:26 PM, sanjesh kumar <kumarsanjesh2004@yahoo.com> wrote: > Thank you Olivia. > > i think this works Olivia Bacha >>T ry this: >> >> egen sum_x=total(x) >> gen Sum=sum_x - x sanjesh kumar <kumarsanjesh2004@yahoo.com>: >>> i have a variable which varies >> across countries over time. say i have 100 countries in year 2000 for a variable >> X. i want to create a sum of variable X over all countries leaving the >> observation of nth country. this i need to do for each country. for example i >> have >>> >>> country year x Sum(x) >>> Australia 2000 6 16 >>> New Zealand 2000 4 18 >>> United States 2000 8 14 >>> UK 2000 3 19 >>> China 2000 1 21 >>> >>> i would like to get a command which gives me the values in the last column. >> for Australia the values in the last column is 16 (=4+8+3+1), for New Zealand it >> is 18 (=6+8+3+1), for United States it is 14 (=6+4+3+1) and for other countries >> it follows the same pattern. i would like to do this for all the countries in my >> sample and for every year. * * 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**:**st: Sum variable over all countries excluding observations from nth country***From:*sanjesh kumar <kumarsanjesh2004@yahoo.com>

**Re: st: Sum variable over all countries excluding observations from nth country***From:*Olivia Bacha <oliviabacha@gmail.com>

**Re: st: Sum variable over all countries excluding observations from nth country***From:*sanjesh kumar <kumarsanjesh2004@yahoo.com>

- Prev by Date:
**Re: st: RE: Mean test in a Likert Scale** - Next by Date:
**st: variation in estimation sample with mi estimate & svy** - Previous by thread:
**Re: st: Sum variable over all countries excluding observations from nth country** - Next by thread:
**st: merging datasets** - Index(es):