Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | David Kantor <kantor.d@att.net> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: forvalues, panel data |
Date | Thu, 30 Sep 2010 09:37:14 -0400 |
--David kantor.d@att.net At 05:58 AM 9/30/2010, Biljana wrote:
I have panel data (companies, fiscal years) and need to deflate numbers to US$ 1980 tsset gvkey_n fyear I used forvalues function and did it like this: First I created variable just with dots: gen dI2=. Then simple forvalues loop .forvalues fyear = 1980/1990 { .replace dI2=I2*1 if fyear==1980 .replace dI2=I2*0.967059 if fyear==1981 .replace dI2=I2*0.421106 if fyear==1982 ... .replace dI2=I2*0.307175 if fyear==1990 } So that works, but since I have 10 variables (from I1 to I10) that need to be deflated, repeating the whole procedure is time consuming... so I tried by using var i=I1-I10, etc... but always got reply invalid syntax... [...]
* * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/