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
Setting up dataset for rds_networkHi, I need to create the respondent-driven sampling variables identifying recruits from two variabl…
How to do k-fold cross-validation on bayesian model?Hello, I wirte a bayesian model, and I want to do cross-validation on the model. More specifically, …
Spatial Panel Model: How use W matrix when is defined by user?Hi All This is my first post but I have learnt a lot from this forum in previous years. I am tryin…
Storing and accessing output of multiple estimation commands within programI've defined a program that generates random data and calls two estimation commands: reg and ppml. I…
Random sorting before 1:1 matching?Dear all, This is a question (more) related to the concept of propensity score matching (PSM). The f…
Subscribe to:
Post Comments (Atom)
0 Response to Esttab formatting to numbers in excel file
Post a Comment