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

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/

**References**:**st: Generating a new variable....tricky question?***From:*"A. Acharya" <aa464@cam.ac.uk>

- Prev by Date:
**st: Generating a new variable....tricky question?** - Next by Date:
**st: AW: Generating a new variable....tricky question?** - Previous by thread:
**st: Generating a new variable....tricky question?** - Next by thread:
**st: AW: Generating a new variable....tricky question?** - Index(es):

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