[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"Brooks Taggert J" <brooks.tagg@uwlax.edu> |

To |
<statalist@hsphsun2.harvard.edu> |

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. TJ -----Original Message----- From: Scott Merryman [mailto:merryman@icehouse.net] Sent: Monday, July 15, 2002 6:15 PM To: statalist@hsphsun2.harvard.edu 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" <brooks.tagg@uwlax.edu> To: <statalist@hsphsun2.harvard.edu> 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/

**Follow-Ups**:**st: RE: RE: Re: Panel data manipulation question***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

**st: RE: RE: Re: Panel data manipulation question***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

- Prev by Date:
**st: RE: Re: Panel data manipulation question** - Next by Date:
**st: RE: RE: Re: Panel data manipulation question** - Previous by thread:
**Re: st: Re: Elasticities** - Next by thread:
**st: RE: RE: Re: Panel data manipulation question** - Index(es):

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