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

[Abdel Rahmen El Lahga <rahmen.lahga@gmail.com>]

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/