st: From: Muhammad Ramzan <ramzan243@gmail.com>

[owner-statalist@hsphsun2.harvard.edu]

Assalam-o-Alaikum


I am working on a panel data having time series from 1981 to 2005.
and no of countries are 120.
I have to take a 5 year average of data for each variable.
like shown below

the original data is
country year y l
1 1981 22 8.7
1 1982 22 8.8
1 1983 23 8.9
1 1984 23 9
1 1985 23 9.2
1 1986 23 9.3
1 1987 24 9.3
1 1988 24 9.5
1 1989 25 9.5
1 1990 25 9.7
1 1991 26 9.8
1 1992 26 9.9
1 1993 27 10
1 1994 27 10.1
1 1995 27 10.1
1 1996 28 10.3
1 1997 28 10.4
1 1998 28 10.5
1 1999 29 10.5
1 2000 29 10.7
1 2001 30 10.8
1 2002 30 10.8
1 2003 31 11
1 2004 31 11.1
1 2005 31 11.2
2 1980 0.233 0.09
2 1981 0.234 0.091
2 1982 0.235 0.09
2 1983 0.236 0.091
2 1984 0.236 0.091
2 1985 0.236 0.09
2 1986 0.24 0.091
2 1987 0.241 0.093
2 1988 0.243 0.096
2 1989 0.244 0.099
2 1990 0.245 0.102
2 1991 0.245 0.104
2 1992 0.246 0.108
2 1993 0.246 0.111
2 1994 0.249 0.113
2 1995 0.247 0.115
2 1996 0.248 0.118
2 1997 0.251 0.12
2 1998 0.251 0.121
2 1999 0.251 0.124
2 2000 0.252 0.125
2 2001 0.252 0.127
2 2002 0.253 0.129
2 2003 0.256 0.131
2 2004 0.255 0.133
2 2005 0.257 0.134
2 2006 0 0


what I want is

years     y5    I5
1981-85 22.6 8.92
1986-90 24.2 9.46
1991-95 26.6 9.98
1996-2000 28.4 10.48
2001-2005 30.6 10.98
1981-85 0.2354 0.0906
1986-90 0.2426 0.0962
1991-95 0.2466 0.1102
1996-2000 0.2506 0.1216
2001-2005 0.2546 0.1308



any code for this .

Regards
Muhammad Ramzan
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/