Announcement

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

  • Help - estout export to csv - a whole row is concentrated in one cell

    Hi friends,

    I am trying to export a table to excel using estout. Instead of each value being put in a cell (="..."), for some of the lines I get one cell with all the values, some of them distorted.

    Your help will be appreciated, Thanks!

    Click image for larger version

Name:	Screenshot 2021-10-31 112118.png
Views:	1
Size:	29.3 KB
ID:	1634021
    Click image for larger version

Name:	Screenshot 2021-10-31 112040.png
Views:	1
Size:	50.2 KB
ID:	1634022

  • #2
    I believe you need to change your output filename from "AllSpec.CSV" to "AllSpec.csv" to create a csv file, or if the capitalization is important to you, add the csv option to the esttab command. See the description of the document format options in the output of the help esttab command for a longer description of the document format options and their defaults.

    I believe that your example created a fixed-format text file, which you could see by opening it in a plain text editor.

    Comment


    • #3
      Of course!
      Thank you!

      Comment

      Working...
      X