Scott and Nick Cox-
This is indeed a neat little solution, but It won't work for me as I
have an unbalanced panel...I have a different number of years for each
country. However now that I think about it the main data I'll need for
this paper is consistent across countries so I could balance it, then
run your suggestion.
Thanks much.
TJ
-----Original Message-----
From: Scott Merryman [mailto:[email protected]]
Sent: Monday, July 15, 2002 6:15 PM
To: [email protected]
Subject: st: Re: Panel data manipulation question
I think something like this should work. Using data available from
Stata
Press website:
use http://www.stata-press.com/data/r7/grunfeld.dta, clear
gen m10 = mv if company == 10
for num 180(-20)20 : replace m10 = m10[_n +X ] if m10== .
gen X = mv / m10
This will create variable X, the market value (mv) of each firm divided
by
the market value of firm 10.
Scott Merryman
----- Original Message -----
From: "Brooks Taggert J" <[email protected]>
To: <[email protected]>
Sent: Monday, July 15, 2002 2:07 PM
Subject: st: Panel data manipulation question
> Statlisters-
>
> I can't seem to figure out how to do this easily, although I'm quite
sure
it must be possible. I have a panel data set on individual countries
and I
want to create a new variable. The variable is going to be the ratio of
a
variable I already have in my dataset, we'll call it P. I want to
create a
variable we'll call X where x=p/p(i==72). That is to say I want to
deflate
all the values of p, by the value of p for country 72, for the
corresponding
year. I thought about trying to grab the time series for that specific
country and appending it to every other country, but that seems awkward.
I've thought about reshaping the data, but that seems tedious as well.
Any
suggestions are always appreciated.
>
>
> Thanks.
>
> TJ
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
