Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Generating a new variable....tricky question?


From   "A. Acharya" <aa464@cam.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   st: Generating a new variable....tricky question?
Date   05 Mar 2009 13:08:21 +0000

hello,


I have a panel dataset with variables for 88 countries each for 5 time
periods.

E.g.
country    year  GDP  FDI
Algeria      1    x    .
Algeria      2    .    .
Algeria      3    .    .
Algeria      4    .    .
Algeria      5    .    .
Argentina    1    y    .
Argentina    2    .    .
Argentina    3    .    .
Argentina    4    .    .
Argentina    5    .    .
etc
etc


Where the dots indicate particular numeric observations. I want to generate
a new variable which for EACH country multiplies FDI by the INITIAL GDP
value in year 1. E.g. for the case of Algeria, FDI in year 1 would be
multiplied by GDP in year 1 (denoted by x), then FDI in year 2 would be
multiplied by GDP in year 1 (denoted by x), then FDI in year 3 would be
multiplied by GDP in year 1 (denoted by x) and so on. Then obviously, once
we get to argentina, it should start multiplying by GDP in argentina's year
1 (denoted by y) and then year 2 FDI in argentina by y and so on.

My question is: How can I generate this variable?

I would really appreciate your help.

Anish
(University of Cambridge)

*
*   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/



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