Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Formatting output into excel, svy: proportions questions.
From
Michael Costello <[email protected]>
To
statalist <[email protected]>
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/