Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Martin Weiss" <martin.weiss1@gmx.de> |
To | <statalist@hsphsun2.harvard.edu> |
Subject | AW: st: AW: -outreg2- super-rows and super-columns |
Date | Thu, 15 Apr 2010 11:05:19 +0200 |
<> Admittedly, the official "Example 8" in -help outreg2- does lead to the error, w/o running anything "twice": ************* sysuse auto, clear reg mpg rep78 head weight turn disp gear outreg2 using myfile, groupvar(Group1 trunk turn head weight Group2) see ************* 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 10:56 An: statalist@hsphsun2.harvard.edu Betreff: Re: st: AW: -outreg2- super-rows and super-columns Thanks Abdel, It did produce an output, but the output did not do the trick of super-row. Please look below. Thanks (1) VARIABLES mpg rep78 0.441 (0.513) headroom -0.163 (0.584) weight -0.00549*** (0.00174) turn -0.154 (0.203) displacement 0.00884 (0.0145) gear_ratio 0.833 (1.733) Constant 38.83*** (9.358) Observations 69 R-squared 0.662 Standard errors in parentheses *** p<0.01, ** p<0.05, * p<0.1 Re: Martin's code, I know that -outreg2- can append second regression results next to the first results. However, I would like to know if it is possible to create a hypotheses column before the first results with some codes look like labcol2(+ ? + -, title("" Hypothesis)) Thanks, Kelvin On Thu, Apr 15, 2010 at 6:44 PM, Abdel Rahmen El Lahga <rahmen.lahga@gmail.com> wrote: > 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/ > * * 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/