Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

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

 From Kelvin Tan To statalist@hsphsun2.harvard.edu Subject Re: st: AW: -outreg2- super-rows and super-columns Date Thu, 15 Apr 2010 18:22:45 +1000

```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
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
>
>
> 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?
>
> 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/
```