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?
Fixed Effects and Random EffectsHi Dear, Can you please tell me whether Fixed Effects estimations with xtreg, fe and Random Effects…
How to compare β coefficients from two different logistic regression models using permutation testHi everyone, I am running two logistic regression models, in which only dependent variables are dif…
Drop commandClyde Schechter I will like will to create a database from an existing data for only individuals ag…
Panel Vardear all, i have stata 13 and i'm trying to do panel var. i've cleaned the data, but whenever i try …
Unifiying databasesDear users of StataCorp forum, As follows I describe my puzzle: Dataset 1 variables: date cusip …
Subscribe to:
Post Comments (Atom)
0 Response to Improving performance of large excel tables with tabout, append - suggestions?
Post a Comment