Exporting data descriptive statistics from stata to excel

[Sanne Bergh]

Dear all,

I am trying to export desriptive "summarize" data from stata to excel.

When trying putexcel I am not alowed to use "using" .
Commands looks as follows : putexcel A1=("Observations") B1=("mean") C1=("sd") D1=("min") E1=("max") using summary_DV.

I have also tried esout: with the following command :
ssc install estout
estpost summarize digital_transformation_keywords digitalization_keywords digital_transformation_keywords
esttab, cells ("observations mean sd min max")

However than I still don't see how it becomes an excel file?

Best,
Sanne

[William Lisowski]

The putexcel command does not work as you think it does; please review the output of help putexcel to better understand the requirements.

Your code

putexcel A1=("Observations") B1=("mean") C1=("sd") D1=("min") E1=("max") using summary_DV

should be

putexcel set summary_DV
putexcel A1=("Observations") B1=("mean") C1=("sd") D1=("min") E1=("max")
putexcel A2=(r(N)) B2=(r(mean)) C2=(r(sd)) D2=(r(min)) E2=(r(max))
putexcel save

[Sanne Bergh]

Thank you!
Another question: how can I use those STATALIST code formats?

[William Lisowski]

See section 12.3 of the Statalist FAQ linked to at the top of every page in the Statalist forum.