The same question was posted two days ago and is available from the Stata
archives
http://www.stata.com/statalist/archive/2004-03/msg00164.html
Rafa
----- Original Message -----
From: "Rodrigo Brice�o" <[email protected]>
To: "Statalist" <[email protected]>
Sent: Friday, March 05, 2004 7:35 PM
Subject: st: Question about sums
> 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/
>
*
* 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/