If I have understood what you really want, try this!!
.sort country
.by country: gen gdp_y1=GDP[1]
.gen FDIgdp_y1= FDI*gdp_y1
hope it helps.
Jeetendra Prakash Aryal
Research Fellow
Department of Economics and Resource Management,
Norwegian University of Life Sciences (UMB)
P.B. 5003, N-1432, Aas
Norway
>-----Original Message-----
>From: [email protected] [mailto:owner-
>[email protected]] On Behalf Of A. Acharya
>Sent: Thursday, March 05, 2009 2:08 PM
>To: [email protected]
>Subject: st: Generating a new variable....tricky question?
>
>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/
*
* 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/
