Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: AW: -outreg2- super-rows and super-columns


From   Abdel Rahmen El Lahga <rahmen.lahga@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: -outreg2- super-rows and super-columns
Date   Thu, 15 Apr 2010 10:44:43 +0200

The problem is when you call outreg twice without runing new
regression the error occurs. Try the code below
cap erase myfile.txt
di in r _rc
sysuse auto, clear
reg mpg rep78 head weight turn disp gear
outreg2 using myfile, groupvar(Group1 trunk turn head weight Group2)
outreg2 using myfile_bis, groupvar(Group1 trunk turn head weight Group2)
outreg2 using myfile, groupvar(Group1 trunk turn head weight Group2)



2010/4/15 Martin Weiss <martin.weiss1@gmx.de>:
>
> <>
>
> Actually, -outreg2- happily appends columns to its output file, so I am not
> sure this is the problem:
>
>
> *************
> cap erase myfile.txt
> di in r _rc
> sysuse auto, clear
> reg price weight length
> outreg2 using myfile
> reg price length rep78 turn
> outreg2 using myfile
> seeout using "myfile.txt"
> *************
>
>
>
> HTH
> Martin
>
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Abdel Rahmen El
> Lahga
> Gesendet: Donnerstag, 15. April 2010 10:29
> An: statalist@hsphsun2.harvard.edu
> Betreff: Re: st: AW: -outreg2- super-rows and super-columns
>
> The erro is caused by the already existing file 'myfile'. You should
> either add option replace to your code
> outreg2 using myfile, groupvar(Group1 trunk turn head weight Group2) see
> replace
> or you could change the name of using file like
> outreg2 using myfile_bis, groupvar(Group1 trunk turn head weight Group2) see
> HTH
> AbdelRahmen
>
> 2010/4/15 Kelvin Tan <kelvin.tan.statalist@gmail.com>:
>> Hi Martin,
>>
>> Thanks for your prompt reply. I don't know why it the code below could
>> not run on my machine. I set trace on, here is the error message
>> (scroll down to see the error message) .
>>
>> Re: super-column example with -estout- is excellent. However, I was
>> wondering if this function could be incorporated into -outreg2-. Or
>> how can I use a combination of both -estout- and -outreg2- to produce
>> a latex format table with hypotheses column? The reason that I stick
>> with -outreg2- because I have spent a huge amount of time to "modify"
>> the code to suit the latex format that I want.
>>
>> Many Thanks,
>> Kelvin
>>
>>
>>
>>
>>
>  ---------------------------------------------------------------------------
> ---------------------------
>> end egen ---
>>    - replace Vorder1=-99 if Vorder1==min
>>    - drop min
>>    - gen varnum = Vorder1 if Vorder1<1
>>    - replace Vorder1=3.7 if rowtype1>=2
>>    - replace Vorder1=Vorder1[_n-1]+.0001 if Vorder1>=3.7 & rowtype1==3
>>    - replace Vorder1=2 if rowtype1==2
>>    - replace Vorder1=3.5 if v1=="Observations"
>>    - replace Vorder1=3.6 if v1=="R-squared"
>>    - replace Vorder1=1 if Vorder1==. & (Vorder1[_n-1]<1 |
> Vorder1[_n-1]==1)
>>    - replace Vorder1=4 if v2=="" & v2plus=="" & Vorder1>3.5
>>    - gen Vorder1_0=.
>>    - local maxnum 1
>>    - if "`sortvar'"~="" {
>>    = if ""~="" {
>>      tokenize `sortvar'
>>      local num 1
>>      while "``num''"~="" {
>>      replace Vorder1_0=`num' if v1=="``num''" | VarName1=="``num''" &
>> Vorder1==1
>>      local num=`num'+1
>>      }
>>      if `num'>`maxnum' {
>>      local maxnum `num'
>>      }
>>      }
>>    - if "`groupvar'"~="" {
>>    = if "Group1 trunk turn headroom weight Group2"~="" {
>>    - count if v1~="" & rowtype1==1
>>    - local nom `r(N)'
>>    = local nom 3
>>    - count if rowtype1==1
>>    - if `nom'~=0 {
>>    = if 3~=0 {
>>    - local many=int(round(`r(N)'/`nom'),1)
>>    = local many=int(round(6/3),1)
>>    - }
>>    - else {
>>      local many 2
>>      }
>>    - tab eqName if rowtype1==1
>>    - local rr=`r(r)'
>>    = local rr=0
>>    - local tempList
>>    - local orderlist
>>    - if `rr'> 0 {
>>    = if 0> 0 {
>>      gen str5 temp=""
>>      replace temp=eqName if eqName~=eqName[_n-1] & rowtype1==1
>>      sort temp
>>      local N=_N
>>      forval num=1/`rr' {
>>      local content=temp[`N'-`num'+1]
>>      local tempList="`tempList' `content'"
>>      local content=eq_order1[`N'-`num'+1]
>>      local orderlist="`orderlist' `content'"
>>      }
>>      drop temp
>>      sort Vord1
>>      local times `rr'
>>      }
>>    - else {
>>    - local times 1
>>    - }
>>    - tokenize `groupvar'
>>    = tokenize Group1 trunk turn headroom weight Group2
>>    - forval kk=1/`times' {
>>    = forval kk=1/1 {
>>    - local order: word `kk' of `orderlist'
>>    = local order: word 1 of
>>    - local temp: word `kk' of `tempList'
>>    = local temp: word 1 of
>>    - local num 1
>>    - local count0 0
>>    - while "``num''"~="" {
>>    = while "Group1"~="" {
>>    - replace Vorder1_0=`num' if (v1=="``num''" | VarName1=="``num''"
>> ) & eqName=="`temp'"
>>    = replace Vorder1_0=1 if (v1=="Group1" | VarName1=="Group1" ) &
> eqName==""
>>    - count if Vorder1_0~=. & eqName=="`temp'"
>>    = count if Vorder1_0~=. & eqName==""
>>    - if `r(N)'==`count0' {
>>    = if 0==0 {
>>    - forval cc=1/`many' {
>>    = forval cc=1/2 {
>>    - local N=_N
>>    - set obs `=`N'+1'
>>    = set obs 17
>>    - local N=_N
>>    - if `cc'==1 {
>>    = if 1==1 {
>>    - replace v1="``num''" in `N'
>>    = replace v1="Group1" in 17
>>    - }
>>    - replace varname="``num''" in `N'
>>    = replace varname="Group1" in 17
>> variable varname not found    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<  ERROR
>> MESSAGE HERE <<<<<<<<<<
>>      replace rowtype1=1 in `N'
>>      replace Vorder1=1 in `N'
>>      replace Vorder1_0=`num' in `N'
>>      if `rr'>0 {
>>      if `cc'==1 {
>>      replace v1="`temp':" + v1 in `N'
>>      }
>>      replace eq_order1=`order' in `N'
>>      replace eqName="`temp'" in `N'
>>      }
>>      }
>>      }
>>      count if Vorder1_0~=. & eqName=="`temp'"
>>      local count0 `r(N)'
>>      local num=`num'+1
>>      }
>>      while "``num''"~="" {
>>      replace Vorder1_0=`num' if (v1=="``num''" | VarName1=="``num''"
>> ) & eqName=="`temp'"
>>      count if Vorder1_0~=. & eqName=="`temp'"
>>      if `r(N)'==`count0' {
>>      forval cc=1/`many' {
>>      local N=_N
>>      set obs `=`N'+1'
>>      local N=_N
>>      if `cc'==1 {
>>      replace v1="``num''" in `N'
>>      }
>>      replace varname="``num''" in `N'
>>      replace rowtype1=1 in `N'
>>      replace Vorder1=1 in `N'
>>      replace Vorder1_0=`num' in `N'
>>      if `rr'>0 {
>>      if `cc'==1 {
>>      replace v1="`temp':" + v1 in `N'
>>      }
>>      replace eq_order1=`order' in `N'
>>      replace eqName="`temp'" in `N'
>>      }
>>      }
>>      }
>>      count if Vorder1_0~=. & eqName=="`temp'"
>>      local count0 `r(N)'
>>      local num=`num'+1
>>      }
>>      if `num'>`maxnum' {
>>      local maxnum `num'
>>      }
>>      }
>>      }
>>    --------------
>>
>>
>> On Thu, Apr 15, 2010 at 5:25 PM, Martin Weiss <martin.weiss1@gmx.de>
> wrote:
>>>
>>> <>
>>>
>>> For the hypotheses column, try
>>> http://repec.org/bocode/e/estout/advanced.html#advanced005
>>>
>>>
>>> Your code runs without problems for me. -set trace on- and see where the
>>> error occurs.
>>>
>>>
>>>
>>> HTH
>>> Martin
>>>
>>> -----Ursprüngliche Nachricht-----
>>> Von: owner-statalist@hsphsun2.harvard.edu
>>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Kelvin Tan
>>> Gesendet: Donnerstag, 15. April 2010 09:11
>>> An: statalist@hsphsun2.harvard.edu
>>> Betreff: st: -outreg2- super-rows and super-columns
>>>
>>> Hi All,
>>>
>>> I follow the helpfile from -outreg2- to create a supper-row, but I
>>> obtained the following error message. Can anyone give me some advice
>>> on this?
>>>
>>> variable varname not found
>>> r(111);
>>>
>>> ---- Begin Code ----
>>> sysuse auto, clear
>>> reg mpg rep78 head weight turn disp gear
>>> outreg2 using myfile, groupvar(Group1 trunk turn head weight Group2) see
>>> --- End Code ----
>>>
>>>
>>> Is it possible to create a "super-column" - a empty column? or is it
>>> possible to create a "predicted sign column" (see below) with outreg2
>>> in stata, then covert it into a Latex format? I need this predicted
>>> column because it is very hard to create a column in a Latex table.
>>>
>>>
>>> Variable |Predicted Sign| Coefficients
>>> trunk  (+)       -0.316**
>>>                 (0.134)
>>> turn       (-)      -0.761***
>>>                  (0.131)
>>> Constant          55.82***
>>>                 (4.354)
>>>
>>> Observations    74
>>> R-squared       0.552
>>>
>>> Regards,
>>> Kelvin
>>> *
>>> *   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/
>>>
>>>
>>> *
>>> *   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/
>>>
>>
>> *
>> *   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/
>>
>
>
>
> --
> AbdelRahmen El Lahga
>
> *
> *   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/
>
>
> *
> *   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/
>



-- 
AbdelRahmen El Lahga

*
*   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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index