>>> [email protected] 03/24/04 11:27pm >>>
Country Code Year GDP
BAN 1960 65
BAN 1965 75
BAN 1970 85
CAN 1960 25
CAN 1965 35
CAN 1970 45
>>>>>
In line with what you have written, try this:
use data
sort countrycode year
encode countrycode,gen(id)
tsset id year
gen coeff=.
forv id=1/2 {
reg gdp year
replace coeff=_b[year] if id==`id'
}
This will give you a column of all values for coeff for each country code. You can then drop repeat values using the duplicates command.
Dev
*
* 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/