Announcement

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

  • Exporting detailed summary statistics to Word

    Hello helpful Stata users,

    I am trying to generate a word export of my dependent variable via the sum function with details.
    Should basically look like this in the end:

    Now I have tried the asdoc export, which somehow seems to transform it into a one line table missing all the useful percentile information and just summing up Obs, Mean and so on...
    > asdoc sum Exports_USD_Hundred_Million, detail

    I have also tried using esttab, however I am unfamiliar with the command and couldn't produce what I was looking for.
    Is there an option for asdoc, which just exports the table like it normally shows in Stata without the asdoc command in front? Or any other way, I can generate output such as in the above picture?

    Thank you very much for any help and advice!

    Kind regards,
    Till

  • #2
    Welcome to Stata list. You will increase your chances of useful answer by following the FAQ on asking questions-provide Stata code in code delimiters, readable Stata output, and sample data using dataex. Also, providing pictures is not recommended – many of us won't open things from strangers and pictures are anything we can work with anyway.

    If you have a nice output in the Stata results window, you can copy it using with the copy table option and it will paste nicely as a table. Given that you are just starting out with Stata, if you can get it this way with a copy and paste I would be strongly inclined not to invest a lot of time trying to automate it unless you're going to do this repeatedly.

    Comment


    • #3
      Try
      Code:
      help asdoc
      It opens a window where you can see lots of options. Chapter 2.2 there is all you need for detailed summary statistics

      you can do, for instance

      Code:
      asdoc summary "variable", stat( N mean min max p1 p99 etc...)
      Last edited by Marco Errico; 01 Jul 2020, 12:14.

      Comment

      Working...
      X