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: Drop Command with several conditions on 2 variables
From
Julian Kochan <[email protected]>
To
[email protected]
Subject
st: Drop Command with several conditions on 2 variables
Date
Sun, 23 Mar 2014 15:59:56 +0100
Hi,
i have a set of data with financial firm characteristics of about 10.000 firms for Year 2000 - Year 2012.
Let's assume: The first column of the data table displays the Name of the firm, the second the Year, the third displays the Cash and the fourth the TotalAssets.
Thus, 13 rows in a row (2000-2012) display information about just one firm - just the year varies.
Problem: I want to drop those firms, for which Cash is greater than TotalAssets in the Year 2007 or Year 2008.
If this is the case, the firm should be dropped out of my data completely such that the firm observation is not only dropped for 2007 and 2008, but also for all the other year.
I tried a lot but it didn't succeed, although some of you guys already helped me with a similar problem.
I would be really really happy to receive an answer.
*
* 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/