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

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