Anish,
how about this:
bysort country (year) : gen newFDI = FDI * GDP[1]
Hope this helps,
Eva
2009/3/5 A. Acharya <[email protected]>:
> 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/
