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
Dropping duplicate observations conditioned on another variableHi, I am using Stata 16.1, and have the following (general) issue. I want to drop duplicate observa…
Create dummy variable to show change in certain timeframe of paneldataHi, I am working with paneldata and want to create a dummy variable that shows me if there is a cha…
Graph with bold ylabelsHi all, I am trying to get bold ylabels in a time series graph. I had success only in xlabel , exam…
Parallel trend test for DID modelDear friends, why the test results using ttable and pstest are not consistent. Code: pstest $xli…
Dropping Observations of Variable according to frequency of occurenceHi, I am working with the following paneldata and want to drop all observations of which I have les…
Subscribe to:
Post Comments (Atom)
0 Response to Esttab formatting to numbers in excel file
Post a Comment