Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: summing variables


From   "Austin Nichols" <austinnichols@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: summing variables
Date   Thu, 26 Jul 2007 17:53:14 -0400

Peggy--
There is a subtle distinction which may have gotten lost in the
shuffle--Maarten's approach (you have to insert an "=0" after "gen
double totalmg" in his example to make it work) puts missing for the
total if any of the components are missing, whereas the -egen-
approach of Ricardo assumes any missings are zero.  I prefer Maarten's
approach for that reason.

E.g.:

clear
set seed 1234567
set obs 10
forv i=1/10 {
qui g mg_`i'=uniform() if uniform()>.1
}
egen totalrsum=rsum(mg_1-mg_10)
gen double totalmg=0
foreach var of varlist mg_* {
qui replace totalmg = totalmg + `var'
}
li total*, noo

On 7/26/07, P chrisman <peggyc@u.washington.edu> wrote:
egen totalmg=rsum(mg_1-mg_108) worked great! Thanks for the assistance. pc
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index