st: generate growths variable out of two other variables

[Julian Kochan <julian.kochan@gmx.de>]

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 TotalAssets. 
Thus, 13 rows in a row (2000-2012) display information about just one firm - just the year varies.

Problem:  I want to to drop those firms for which the Asset growth from 2006 to 2007 is higher than 400 %
		  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 2006 and 2007, but also for all the other years.
		 
	         Thus I want to generate a variable for which asset growth from 2006 to 2007 is higher than 400 %. Here is my problem.
		 generate asset_growth if ("TotalAssets in 2007/ Total Asset in 2006 > 400%.") 
		 How do I include the years correctly ? 

		 generate asset_growth =  ((TotalAssets & Year==2007)/(TotalAssets & Year==2006)) doesn't work. It gives me a "0" for each firm in Year 2006. 
		 I want Stata to display the growth of Assets in eather the 2006 line or 2007 line. 
		
		

I would be really really happy to receive an answer.

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