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

[Nick Cox <njcoxstata@gmail.com>]

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/