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
GSEM Interpretation HelpHi everyone, I'm new to structural equation modeling but my advisor suggested I try it based on my …
Bootstrapped confidence intervalsHello, I have to use bootstrapping to add 90% confidence intervals to a ratio. How could I do that? …
Difference in Differences with cross sectional data - continuous treatment (didregress)Hello Members, I have a pressing doubt in implementing the diff in diff in Stata 17. - didregress c…
Help with graphing results of the synthetic control methodI've been struggling to perform placebo test and finding p-values after running a synthetic control …
Multinomial logit model with random effectsDear all, I am working on the data of traffic violations recorded in one year. as shown in the tabl…
Subscribe to:
Post Comments (Atom)
0 Response to Esttab formatting to numbers in excel file
Post a Comment