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?
Eaalogit: Attribute non-attendance within classesHello Statalist, I am trying to control for attribute non-attendance in a choice experiment. The ch…
Identifying closest date to another date variableHi, i have a table with announcement date (anndat) and statistical period which is counts as a forec…
Adding tests to regression resultHello! I am studying econometrics and I do not know how to add F/Wald Stat, within, between, overall…
Replace string with a variable while leaving empty another string variableDear all, I have different variables indicating different names of health providers (prov1, prov2 e…
closest date to another date variableHi, i have a table with announcement date (anndat) and statistical period which is counts as a forec…
Subscribe to:
Post Comments (Atom)
0 Response to Improving performance of large excel tables with tabout, append - suggestions?
Post a Comment