Dear Statalist,
I have been an avid reader of the list for years and it has helped me tremendously in so many situations. I know that people are not crazy about providing feedback on user-written commands. Still, I was wondering whether anybody had any suggestions for me. I am not looking for a solution (I don't think there is a simple solution), rather for suggestions for optimisation.
I like using tabout (SSC) to create nicely formatted tables in excel right from Stata. However, for some projects I have to create a lot of descriptive statistics in tables (sometimes 100+ across multiple sheets), that ideally should be in one output file, otherwise I am afraid things get messy and version control is difficult.
tabout works great for me generally. However, once I start adding several tables on multiple sheets in Excel combining loops with the tabout, append option (let's say, 30+ tables), it starts slowing down massively.
Has anybody else experienced similar issues when creating many tables using tabout, append? Does anybody have any suggestions for improved performance?
Related Posts with Improving performance of large excel tables with tabout, append - suggestions?
Inconsistency between correlation analysis and regression resultsHi Statalist, I have the panel data (state-year) and run a correlations analysis between my y and x…
svy: reg get standardized coefficients for both continuous and categorical predictorsHi Statalist, I came across an issue for getting standardized coefficients for svy: reg, when there…
Count dependent variable with many zero valuesHi My dependent variable is the number of policies that a company has adopted in the given year. It…
separate regression of different groups in the panel dataHi everyone! I seem to stuck in the problem of doing regression of different groups within the panel…
How to draw cubic splines after Cox regressionHello, Could anybody help me with syntaxis to do this graph? y axis= hazard ratio. x axis= covariate…
Subscribe to:
Post Comments (Atom)
0 Response to Improving performance of large excel tables with tabout, append - suggestions?
Post a Comment