Announcement

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

  • #16
    Creating publication quality regression tables with asdocx is simple and slick. I'll be glad to see if asdocx allows statistics other than those available in the e() macro in its stat() option, specifically, summary statistics such as mean, standard deviation, skewness, and kurtosis for the dependent variable.

    Comment


    • #17
      Hello Liliani
      Thanks for your feedback. Have you tried the add() option that is documented in the help file of asdocx, Section 4.8. First you need to find the relevant statistic using sum command, write the statistic to a macro and finally pass that macro to the add() option. I am copying the text from the help file here for reference.

      4.8 add(text1, text2 | text3, text4...)
      This option adds text legends to the bottom cells of the nested regression table. This option is usually used to show the presence or absence of some variables in the respective regression models. For example, we might include firm, year or industry dummies in a regression model and just indicate with 'yes' or 'no' the presence of these dummies. This version of asdocx supports up to a maximum of three categories of legends. The text legends should be added in pairs of two, each one separated by a comma.
      Last edited by Attaullah Shah; 12 Jan 2022, 12:02.
      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


      • #18
        Thank you Dr Shah for your suggestion. I can see two problems here:
        1. The option add() is limited to only three cases, so if I have more statistics, I think it will not work.
        2. I shall have to write several lines of code to get a desired statistic, which might unnecessarily increase the code length.
        I hope there is a more flexible and easy solution to this.

        Comment


        • #19
          I agree. Let me figure it out. Once ready, I shall post a beta version for testing. Thanks for your suggestion.
          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


          • #20
            Just started using asdocx and, besides some issues with having files saved on Dropbox (thank you Attaullah Shah for being patient with me), seems like a good programme.
            One thing on my wish list would be the possibility to save results in separate worksheets of the same Excel file. Would work very well with looping the same command across different variables (for example regressions with same set of predictors but different dependent variables). Something like save(my_regressions.xlsx) sheet(`var')

            Comment


            • #21
              Cristian Dogaru Thanks for your feedback and suggestion. I have noted it. I shall post my updates here once I have a working solution.
              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


              • #22
                Hello Cristian Dogaru
                The beta version of asdocx is now available for testing. You can install the beta version as
                Code:
                asdocx_update, beta
                Here is a working example to show the use of the new option sheet().
                Code:
                sysuse auto
                asdocx sum, replace sheet(sum) save(file.xlsx)
                asdocx cor,  sheet(cor)
                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

                Working...
                X