Re: st: capturing estimated means and standard errors into a new data set

[Nick Cox <njcoxstata@gmail.com>]

I've not tried to understand the details here, but it sounds like a
case for -statsby-.

Nick

On Tue, May 15, 2012 at 11:53 PM, Kevin Geraghty <kevin@ecotope.com> wrote:
> I am sure many have confronted this problem:
>
> I have a variable with some partition of subgroups defined , and want to capture the mean of that variable and accompanying standard error, for each value of the subgroup partition, into a stata data set.
>
> I have written code to confront this problem pulling data out of the returned  matrices and dumping it into a temporary dset, but it is frankly pretty ugly and I am hoping someone can show me a more economical way to do this.
>
> Here's what I have. note that "plat" is the name of the partition variable which defines subgroups. I am using the complex survey version of the mean command, but I believe the problem is identical with the standard version of the mean command:
>
>    tempfile outfile
>    local testvar <name of variable of interest>
>
>    svy: mean `testvar', over(plat) level(90)
>    preserve
>        clear
>        matrix fu = e(b)'
>        local vplatnames: rowfullnames fu
>        local plats: subinstr local vplatnames "`testvar':" "", all
>        svmat fu, names(col)
>        rename y1 `testvar'_mean
>        format `testvar'_mean %9.3f
>        gen int plat=.
>        local i 0
>        foreach plat of local plats {
>            replace plat = `plat' in `++i'
>        }
>        save `outfile', replace
>
>        clear
>        matrix var = vecdiag(e(V))'
>        local vplatnames: rowfullnames var
>        local plats: subinstr local vplatnames "`testvar':" "", all
>        svmat var, names(col)
>        replace r1 = sqrt(r1)
>        rename r1 `testvar'_sd
>        format `testvar'_sd %9.6f
>        gen int plat=.
>        local i 0
>        foreach plat of local plats {
>            replace plat = `plat' in `++i'
>        }
>        merge 1:1 plat using `outfile', nogenerate
>        save `outfile', replace
>    restore
>

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