Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: Re: Panel data manipulation question

From   "Brooks Taggert J" <[email protected]>
To   <[email protected]>
Subject   st: RE: Re: Panel data manipulation question
Date   Tue, 16 Jul 2002 09:26:40 -0500

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.

-----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
Press website:

use, 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
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
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
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
all the values of p, by the value of p for country 72, for the
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.
suggestions are always appreciated.
> Thanks.
> TJ

*   For searches and help try:
*   For searches and help try:

© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index