Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Formatting output into excel, svy: proportions questions.


From   Michael Costello <michaelavcostello@gmail.com>
To   statalist <statalist@hsphsun2.harvard.edu>
Subject   st: Formatting output into excel, svy: proportions questions.
Date   Thu, 16 Dec 2010 17:52:23 -0500

Dear Statalisters,

I'm slowly growing into my Stata, learning more and asking more.
Today I came across two problems that I want to ask for help with:
1.  I have a quantitative variable with a large proportion of zeros.
Short of creating a new variable, is there a way to run "svy: prop
variable" and add in some option that would produce only the zero
score proportion, and possible the non-zero proportion, rather than
all ~150 levels as proportions?
2. I'm running the code and receiving the output below, yet I'm
wondering if there is a way to get this output directly into excel,
without the Conf.Int. at all:
. svy: mean age grade female cnonwpm orf zeroorf list_comp_score_pcnt
if grade==2
(running mean on estimation sample)

Survey: Mean estimation

Number of strata =       1          Number of obs    =     571
Number of PSUs   =      63          Population size  = 73508.4
                                   Design df        =      62

--------------------------------------------------------------
            |             Linearized
            |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
        age |   8.536152   .1011248      8.334007    8.738298
      grade |          2          0             .           .
     female |   .5647884   .0147713      .5352609    .5943158
    cnonwpm |   20.11004   1.011389       18.0883    22.13178
        orf |   44.42609   3.028574      38.37206    50.48013
    zeroorf |   .2323212   .0220831      .1881777    .2764646
list_comp_~t |   .4378731   .0213059      .3952832    .4804631
--------------------------------------------------------------





--
Michael Costello
MS Candidate, Statistics 2011
202-246-1627
Linked In

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


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index