Re: st: Using outreg2 within a loop

[Suryadipta Roy <sroy2138@gmail.com>]

John,
Thank you very much indeed for the response! This is exactly what I
needed! I figured that -xttobit- does not return the adjusted
R-squared, but was carrying it over from another command.

Sincerely,
Suryadipta.


On Wed, Feb 13, 2013 at 2:56 PM, John Luke Gallup <jlgallup@pdx.edu> wrote:
> Suryadipta,
>
> There is probablly a way to do this in -outreg2-, but I am not familiar with its details.
>
> If it is useful, though, you can do what you are looking for with -outreg-, also an SSC user-written command:
>
> outreg, clear
> forvalues i = 1(1)5 {
>         xttobit dep_var `controls' if period == `i', ll(0)
>         outreg using "C\file.doc", bdec(2) squarebrack keep(var1 var2) ///
>                 summstat(r2_a) summtitle(Adj. R-squared) merge
> }
>
> The -keep- option strips off the sigma statistics (and the constant).  Note that there doesn't seem to be an e(r2_a) statistic saved by -xttobit-, however.  The outreg -merge- option can be used in the first iteration of a loop even if there is nothing to merge to, but it requires the -outreg, clear- command preceding the loop to prevent the endless accumulation of new columns of results when you rerun the .do file.
>
> John
>
>
> On Feb 13, 2013, at 6:43 AM, Suryadipta Roy <sroy2138@gmail.com> wrote:
>
>> Dear Statalisters,
>>
>> I am using the following form of code to get the regression results
>> within a table using -outreg2- :
>>
>> forvalues i = 1(1)5 {
>> xttobit dep_var `controls' if period == `i', ll(0)
>> outreg2 using "C:\file.doc", nocons tstat dec(2) bracket keep(var1
>> var2) addstat(Adj. R-squared, e(r2_a)) word label `append'
>> local append "append"
>> }
>>
>> When the file gets saved, two separate columns for "sigma_u" and
>> "sigma_e" are added for each of the five regressions. While I can
>> delete the columns manually, I was wondering if there is a suggestion
>> as to how to prevent them from appearing in the first place. Any
>> suggestion is greatly appreciated.
>>
>>
>> Sincerely,
>> Suryadipta.
>> *
>> *   For searches and help try:
>> *   http://www.stata.com/help.cgi?search
>> *   http://www.stata.com/support/faqs/resources/statalist-faq/
>> *   http://www.ats.ucla.edu/stat/stata/
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/