Hi Statalist,
I am using esttab from SSC in Stata 16.1 to make summary tables of tab (percents) in excel. In the excel cells, it is fomatting the output as ="". For example, using the sample code below it's outputting Domestic frequency in the excel cell as ="52" (visually appears as 52). Is there some way to have the output be a plain number in excel so the cell shows 52 (without the ="")?
Thank you!
sysuse auto
eststo clear
estpost tab foreign
esttab using example.csv, cells("b(label(freq)) pct(fmt(2))") varlabels(, blist(Total)) nonumber noobs replace
Related Posts with Esttab formatting to numbers in excel file
How to reshape data for analysis (Discrete choice experiment)Hi there, hello to the community. I'd need some help with how to prepare/shape data for analysis fro…
Would this be a good instrumental variableI am running a regression : hours worked per year= days ill per year+ age+ gender+ region + u. Would…
ppml (gravity equation) with quadratic term of the distance variableHello, Here is my question: I am testing the curvilinear (inverted U-shape) effect of distance (cu…
Stata 10.1I am currently using Stata 15. However, some user-written commands do not work in Stata 15 and requi…
Extracting unique strings from multiple variables for each observationI have school level data with the name of different counties they have belonged to across a number o…
Subscribe to:
Post Comments (Atom)
0 Response to Esttab formatting to numbers in excel file
Post a Comment