thanks a lot for the prompt replies. however, i think i didn't explain my
problem accurately.
i'll start from the end result perhaps it makes more sense this way. please
bear with me.
in the end, i would like to have a matrix (to be exported in excel) with
columns:
varname coeff1 stderr1 coeff2 stderr2....
the variables under varname come from the varlist `outcomes' i described in
the previous email (i.e. local outcomes " an_abbreviated_varlist ").
to obtain the above mentioned matrix, i'm thinking of implementing the
following loop:
foreach var of varlist `outcomes' {
reg `var' x1 x2...
now somehow generate a scalar indexed by the position of `var' in
varlist (i.e. scalar1 for first variable, scalar2 for second), equal
to the coefficient of x1
do the same for the stderror of x1, coeff of x2, and so on
}
after the loop is done take these scalars and put them into the above
mentioned matrix. the part i don't know how to do is to generate those
scalars
If you want to export your proposed matrix to Excel, then the best way
might be to create this matrix as a Stata data set, with 1 observation per
model and variables -varname-, -coeff1-, -stderr1- etc., and then to export
it to an Excel-compatible generic text spreadsheet using -outsheet-.
