Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Question about sums


From   Douglas Crawford <dcrawfo@itsa.ucsf.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Question about sums
Date   Fri, 5 Mar 2004 12:03:49 -0800

Do you want row sums?

If so you can use

egen sumv1_v4 = rsum(var1-var4)

Cheers,

Douglas

On Mar 5, 2004, at 11:35 AM, Rodrigo Briceņo wrote:

Dear friends of the list. I want to know how to deal with missings when I
need to make a sum. Suppose that I have the following variables:

v1 v2 v3 v4
200 . 30 .
. 350 . 100
280 100 30 .

In my original database each of those variables represents a source of
income and the values are the quantities reported in the survey. I want to
generate a new variable that sums all the reported values, but when I do
this directly I get only missings. I guess that is caused by the sum of
missing data, but I don't know a procedure to sum only values reported and
not missings.

Thanks for helping me!



________________________

Rodrigo Briceņo
Consultor
Sanigest Internacional
Telf. Oficina: (506) 280-5457
Fax: (506) 234-1486
Celular: (506) 357-4535
www.sanigest.com
_______________________

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




Douglas Crawford
Ph.D. Candidate, Dept. of Biochemistry UCSF
Executive Director, Innovation Accelerator
600 16th Street, Room S314
San Francisco, CA 94143-2200

Phone: 	415-476-9869 xt. 7#
Fax:		415-514-4147


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