Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • exprot regression table to word or excel

    Hi all,
    i have cretaed a regression table using estout command usning the code below
    Code:
    regress bmi psaa age sex
      estimate store BMI
      regress bai psaa age sex
      estimate store BAI
      regress fmi psaa age sex
      estimate store FMI
      estout BMI BAI FMI, cells(b(star fmt(3)) se(par fmt(2))) legend label varlabels (_cons constant)   stats (r2 df_r bic, fmt(3 0 1) label (R-sqr dfres BIC))
    I want now to export this table to word or excel. i need your help please

    regards



    stata 15.1 mac

  • #2
    Here is a solution based on asdoc
    Code:
    ssc install asdoc
    asdoc reg bmi psaa age sex, nest replace
    asdoc  reg bai psaa age sex, nest
    asdoc reg fmi psaa age sex, nest label stat(df_r bic)
    Output based on some dummy data
    Click image for larger version

Name:	Capture.PNG
Views:	1
Size:	46.5 KB
ID:	1517736


    For those who are not yet familiar with asdoc, asdoc can be downloaded from SSC and can be used with almost all Stata commands. Here is a short blog post that shows how asdoc can be used with any Stata command http://fintechprofessor.com/2018/02/...basic-example/. You can also watch several YouTube videos that show the use of asdoc https://www.youtube.com/watch?v=zdI6...LwodAk2oqLYhr-

    Code:
    * For installation of the stable version 
    ssc install asdoc
    
    * For installation of the new beta version
    net install asdoc, from(http://fintechprofessor.com) replace
    help asdoc
    Regards
    --------------------------------------------------
    Attaullah Shah, PhD.
    Professor of Finance, Institute of Management Sciences Peshawar, Pakistan
    FinTechProfessor.com
    https://asdocx.com
    Check out my asdoc program, which sends outputs to MS Word.
    For more flexibility, consider using asdocx which can send Stata outputs to MS Word, Excel, LaTeX, or HTML.

    Comment


    • #3
      There are many procedures for exporting results - estout, outreg, outreg2, asdoc. Stata now provides its own exporting facilities (look at the Reporting documentation in Stata 16) but they seem a little more complex to use than the user-written versions. Which you use is probably a matter of taste and habit.

      Comment

      Working...
      X