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?
How to detect sources of variations in coefficients obtained from a panel data regression?Is it possible to identify whether and how cross-sectional variation and/or time-series variation co…
random numbers to groups of random sizeHi Statalisters! I have the following problem. I have N individuals and I would like to assign to t…
HELP!! Interpreting logged dependant varaible, when its a ratio.Hi Guys, I apologise if this question is hard to read. I'm currently analysing a regression in whic…
How to run marginal effect for multinomial probit in STATAMy dependent variable has four categories, including 1) working & studying; 2) working but not s…
Transforming VariablesHI! if i want to (using data from January 1971 to December 2020) transform the the month and year va…
Subscribe to:
Post Comments (Atom)
0 Response to Improving performance of large excel tables with tabout, append - suggestions?
Post a Comment