[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Panel data manipulation question
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.
Taggert J. Brooks, PhD
Assistant Professor of Economics
Department of Economics
University of Wisconsin - La Crosse
403O North Hall
1735 State Street
La Crosse, WI 54601
Phone: (608) 785-5295
Fax: (608) 785-8549
"At the age of six I wanted to be a cook. At seven I wanted to be Napoleon. And my ambition has been growing steadily ever since."
* For searches and help try: