Michael833/EGRA---Intern-work — Issue #67: outtable: oddities
Author: Michael833
Created: 2012-01-02 00:07:13+00:00
State: open
Labels: -Ext-, Coding Bug

testouttable seems to be working great! Thanks so much. I did find a few oddities that I wanted to point out.

1. When no subpops are specified, we need to drop the auto-generated "__000000" variable before output.
if "`subpop'"=="" drop __000000 (I'm just a little too shy to put it in right now.

2. count_2 is printing out after pcnt_increase and effect_size. I fixed this, but I just wanted you to know (in case it breaks something else, which I doubt) that the current output order is mean, sd, count.

3. There still seems to be some kind of "sort" problem in the function. Here is a bit of code that should cause a problem if you run it a few times in a row:
use "Z:\Task 3 EGRA\Final Databases\Malawi\3. National EGRA Malawi 2010-2011 Wgt, T HT.dta", clear
outtable *score_zero, over(treat_phase)subpops(region female) to(Alex:put this some place local) tstats effects svy type(Excel) ///
excel(sheet(ZeroScoresRegGen) sheetreplace firstrow(variables)) order(subtest)

4. There is a matrix being printed as part of the output. I believe it's on (about) line 463 "list , noobs" Can we either a) quietly: or b) remove it all together? Is there a purpose behind it?

I'm trying to be helpful here by fixing myself or suggesting solutions. If that's annoying, tell me and I won't do that.

-Michael