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

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

 From Michael Costello To statalist 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
(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