Hi Statalist!

I have a panel data set with multiple variables (X1, X2, ...). I am trying to run a multivariate regression for each country separately and store the coefficients in a single table. So far this is what I have:

tempname output
postfile `output' ID X1 X2 X3 X4 using output.dta,replace
levelsof ID, local(C)
foreach i of local C{
qui regress Y X1 X2 X3 X4 if id==`i'
post `output' (`i') (`=_b[X1]') (`=_b[X2]') (`=_b[X3]') (`=_b[X4]')
}

postclose `output'

My problem is that the "ID" variable has a long format and I am getting numbers in the output file, instead of actual country names. I do have a variable "country" that has a string format, but I just don't know how to transfer it to this new output file.

Any help would be much appreciated.