sem output to Excel – asdocx estat teffects

[Jonnatan Fajardo]

#18564

Hello, with asdocx estat teffects, is there a way to export to excel? Additionally, is there a way to add 95% CI?

Thank you,
Jonn

[Attaullah Shah]

#18566

You can send the teffects output to Excel by setting the output type to Excel before running the estat teffects option with asdocx. Here is an example:

asdocx setfile, save(MyTable.xlsx)

webuse sem_sm1, clear
sem (r_occasp <- f_occasp r_intel r_ses f_ses) ///
(f_occasp <- r_occasp f_intel f_ses r_ses), ///
cov(e.r_occasp*e.f_occasp)

asdocx estat teffects

2. asdocx creates teffects output from the stored matrix returned by Stata. This matrix does not contain confidence intervals. If confidence intervals are required, they must be calculated and appended to the matrix before being written to a file using asdocx

[Author]

Posts