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]

Re: st: Replace with returned results in svy loop


From   Richard Williams <richardwilliams.ndu@gmail.com>
To   statalist@hsphsun2.harvard.edu, statalist@hsphsun2.harvard.edu
Subject   Re: st: Replace with returned results in svy loop
Date   Sun, 29 May 2011 19:11:52 -0500

If in doubt where a value is stored, type -ereturn list- after the estimation command. After -mean-, e(b) has the mean of the variable. So, to get the mean stored in a scalar, do something like

webuse nhanes2f, clear
svy: mean houssiz
mat varmean = e(b)
scalar vmean = varmean[1,1]

Having said that, substituting the mean for missing data is generally not considered the best practice in the world. And, there may be other errors in your code (e.g. the == in the replace command looks wrong) but I imagine those will become obvious once you tidy other things up.

At 03:11 PM 5/29/2011, Kate Schneider wrote:
Hello,
Sorr to bug everyone on a holiday weekend, but we're a graduate
student research group at the University of Washington working with a
large household survey dataset and have come up against some trouble.

We're trying to replace missing values of a variable with the results
of some other operation we've just performed (basically, a mean).
Right now, we're having trouble with the replace component of the
below operation. Does anyone know how torecall the previous command's
results from the svy calculation and use that data to replace missing
in a loop?  Is this possible with survey data?

foreach X of varlist $fooditemall {
quietly count if `X'==1 & priceperkilo !=.
 if `r(N)'>0 {
 display "Variable is: " "`X'"
 svy, subpop(`X'): mean priceperkilo
 }
quietly count if `X'==1 & priceperkilo ==.
 if `r(N)'>0 {
 replace priceperkilo == e(????) if `X'==1 & priceperkilo ==.
 }
}

Thanks for your insight!  If you need more information please let me know.
Kate

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

-------------------------------------------
Richard Williams, Notre Dame Dept of Sociology
OFFICE: (574)631-6668, (574)631-6463
HOME:   (574)289-5227
EMAIL:  Richard.A.Williams.5@ND.Edu
WWW:    http://www.nd.edu/~rwilliam

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