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

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/

**Follow-Ups**:**st: RE: Generating a new variable....tricky question?***From:*Jeetendra Aryal <jeetendra.aryal@umb.no>

**st: AW: Generating a new variable....tricky question?***From:*"Martin Weiss" <martin.weiss1@gmx.de>

**Re: st: Generating a new variable....tricky question?***From:*Eva Poen <eva.poen@gmail.com>

- Prev by Date:
**Re: st: stata resources available for funnel plots?** - Next by Date:
**Re: st: Generating a new variable....tricky question?** - Previous by thread:
**st: stata resources available for funnel plots?** - Next by thread:
**Re: st: Generating a new variable....tricky question?** - Index(es):

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