I'd look at -collapse- and/or -tabstat-.
In any case, your loop
foreach group of varlist FF_group_rank_0 {
}
will do nothing as `group' is never referred to inside the loop. That probably doesn't matter, but it shows some confusion about what -foreach- does.
Nick
n.j.cox@durham.ac.uk
qing ye
Do any of you know how to report the results calculated after the loop
as tables??
forvalues i=1990 (1)2010 {
foreach group of varlist FF_group_rank_0 {
forvalues n=1(1)6{
quietly sum EI_t if
trade_date_yearformat==`i' &FF_group_rank_0==`n'
local s_EI=r(sum)
quietly sum BE_t_1 if
trade_date_yearformat==`i' &FF_group_rank_0==`n'
local s_BE=r(sum)
local mean_EI_BE=`s_EI'/`s_BE'
}
}
}
I wanted to have the mean_EI_BE I calculated in the loops reported as a table
something like the following:
year group1 group2 group3 group4 group5 group6
1990 x x x
1991 x x x
1992 x x x
1993 x x x
....
How do I do this? Do I need to use matrix commends to save the
mean_EI_BE I calculated each time or do I need to generate some
variables before the loop and store the mean_EI_BE in those variables?
*
* 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/
