Bookmark and Share

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]

st: RE: Dropping all subjects but those in the last period


From   "Cohen, Elan" <[email protected]>
To   "[email protected]" <[email protected]>
Subject   st: RE: Dropping all subjects but those in the last period
Date   Mon, 8 Apr 2013 19:39:35 +0000

Let's assume 2010 is the "last year".  Then:

egen flag = total(year==2010), by(id)
drop if !flag

HTH,

- Elan


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Miguel Angel Duran
Sent: Monday, April 08, 2013 15:27
To: [email protected]
Subject: st: Dropping all subjects but those in the last period

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. Thanks.

Miguel A. Duran.

*
*   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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index