Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: cumulative summation
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: cumulative summation
Date
Tue, 26 Feb 2013 08:17:50 +0000
Note that
egen ties = total(<something>), by(firm year)
presumably could have got you there directly.
Nick
On Tue, Feb 26, 2013 at 7:49 AM, Nick Cox <[email protected]> wrote:
> bysort firm year (ties) : replace ties = ties[_N]
>
> Nick
>
> On Tue, Feb 26, 2013 at 7:08 AM, James Bernard <[email protected]> wrote:
>
>> I have used the sum function to calculate a variable in a panel data.
>>
>> Firm Year ties
>> ----------- ---------- -------
>> A 1990 1
>> A 1990 2
>> A 1991 1
>> B 1990 0
>> B 1990 1
>> B 1990 3
>> C 1990 0
>> C 1991 0
>> C 1992 0
>>
>> The issue is that the variable ties which is the number of ties a firm
>> has formed in a year is a cumulative sum of something and, therefore,
>> for a company like A the final number of ties in year 1990 should be
>> 2. I need the program to write the same number (final value of the
>> cumulative sum) instead of 1.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/