Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


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

st: RE: changing event level panel data to yearly panel data


From   Nick Cox <[email protected]>
To   "'[email protected]'" <[email protected]>
Subject   st: RE: changing event level panel data to yearly panel data
Date   Fri, 17 Jun 2011 18:06:37 +0100

. help collapse 

Nick 
[email protected] 

ramesh

I have a big panel dataset (with respect to event level) as shown
below.

country  year     v1     v2.......
AFG       1985     12     10
AFG       1985     15     51
AFG       1986     10     12
AFG       1986     15     82
AFG       1986     13     92
AFG       1987     16     12
AFG       1987     15     92
AFG       1988     13     52
AFG       2009     16     52

USA      1985     20       25
USA      1985     20       25
USA      1985     20       25
USA      1985     20       25
USA      1986     20       25
USA      1986     20       25
USA      1987     20       25
USA      1987     20       25
...
USA      2009     54        52
USA      2009     54        52.
USA      2009     54        52
USA      2009     54        52
USA      2009     54        52
USA      2009     54        52
......................................
I want to change the event level data to yearly by summing the each
variables over year like:

Country     year     v1    v2....
AFG         1985      27    61
AFG         1986      28    186
.....
USA         1985       
USA         1986
...........................

*
*   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–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index