I am working on a project running regression models for 10 dependent variables and I need to do subgroup analysis for several subgroups: race/ethnicity, gender, marital status, and education level. Currently I am using esttab to output the results into excel. I saved each subgroup category for the 10 dependent variables as one excel file. Since there are so many subgroups, I had to save the results to many excel files and manually to copy the coefficients for my key dependent variables into one big table. It is very time intensive and if I update the model, I need to do it from the beginning. I did this automatically in SAS using ODS function, and macro, and output the results as a SAS data file, then worked on the data file to create the final table for publication automatically. However some of the analyses are easier to do in STATA. I am wondering whether there are ways in stata that i can create the results as a dataset automatically and worked on it to format for publication, or can I output the needed coefficient to an excel file and designate a cell place for the coefficients?

Thanks everybody for help!

Rui