Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: 5-years period averages


From   [email protected]
To   [email protected]
Subject   st: 5-years period averages
Date   Sun, 26 Oct 2003 20:01:44 +0100 (MEZ)

Dear Statalisters,
To avoid temporary external shocks effects, I have restructure my balanced 
panel data in a 5-years averages. I used the following program so far but now 
that I want to try the data set in 3-years averages, I found it to be a pain 
if I should type in the full numlist as before.
I would appreciate therefore any suggestion that avoids me typing the numlist.
*****************THE PROGRAM************
version 8.1
use datafilename1, clear 
list  year if id_1, nolab  /*for identifying the number of 5-years periods 
necessary -(panel of 7 countries)-*/
sort id year
capture egen tag=tag(id)
save, replace
clear
numlist "1 1 1 1 1 2 2 2 2 2 3 3 3 3 3 4 4 4 4 4 5 5 5 5 5 6 6 6 6 6 7 7 7 7 
7 8 8 8 8 8 9 9"
tokenize `r(numlist)'
local N : word count `r(numlist)' 
set obs `N' 
gen idfifth = . 
forval i = 1 / `N' { 
replace idfifth = ``i'' in `i' /*isn't possible to do that using -bysort id-?
*/
 }
save datafilename2
merge datafilename2 with datafilename1
**********************END****************
By the way the above program creates only one panel i.e. for 1 of the 7 
countries simply because I can't combine  -in `i'- with -by- expression.
Any alternative will be greatly appreciated.
Adama
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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