Statalist


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

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


From   Jeetendra Aryal <jeetendra.aryal@umb.no>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Generating a new variable....tricky question?
Date   Fri, 6 Mar 2009 12:11:33 +0100

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: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
>statalist@hsphsun2.harvard.edu] On Behalf Of A. Acharya
>Sent: Thursday, March 05, 2009 2:08 PM
>To: statalist@hsphsun2.harvard.edu
>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/



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