Hi -
I have calculated the standard deviation of firm-level revenue using the recommended mvsumm command such as:
mvsumm Revenue, stat(sd) win(5) gen(rev5ysd) end
I have the 64-bit version of Stata 10 SE (and a 64-bit computer). My sample size is over 1.1 million observations covering over 200,000 firms over 6 years. It took my computer about 24-hours to compute this statistic (although it worked just as advertised and gave me exactly the result I needed).
Does anyone have any recommendations to speed up computing time since I need to compute about 8 more similar commands and don't want to tie up my Stata for over a week? Or do I just need to accept the calculation time since my data is so large?
Thanks,
Thad Calabrese
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/