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/