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: RE: Dropping all subjects but those in the last period
From
"Miguel Angel Duran" <[email protected]>
To
<[email protected]>
Subject
RE: st: RE: Dropping all subjects but those in the last period
Date
Tue, 9 Apr 2013 12:01:15 +0200
Elan and Nick, thank you very much. It has been magic.
-----Mensaje original-----
De: [email protected]
[mailto:[email protected]] En nombre de Nick Cox
Enviado el: lunes, 08 de abril de 2013 21:51
Para: [email protected]
Asunto: Re: st: RE: Dropping all subjects but those in the last period
As Elan implies, Stata is very good at such problems. There is certainly no
need for intricate choreography with files. Here is another solution:
bysort id (year) : drop if year[_N] < 2000
Nick
[email protected]
On 8 April 2013 20:39, Cohen, Elan <[email protected]> wrote:
> Let's assume 2010 is the "last year". Then:
>
> egen flag = total(year==2010), by(id)
> drop if !flag
Miguel Angel Duran
> My dataset includes observations for about 9000 companies per year in
> a twenty years period. To clean the dataset, I would like to drop all
> those companies that are not present in the last year (because the
> rest went bankrupt or were absorbed), but I do not know how to do it.
> Can this be done just by splitting the datasets by period and then
> merging them? Each company has the same id across years.
*
* 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/
*
* 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/