Statalist


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

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


From   Eva Poen <eva.poen@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Generating a new variable....tricky question?
Date   Thu, 5 Mar 2009 13:15:29 +0000

Anish,

how about this:

bysort country (year) : gen newFDI = FDI * GDP[1]

Hope this helps,
Eva


2009/3/5 A. Acharya <aa464@cam.ac.uk>:
> 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