Statalist


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

Re: st: gen & summation again


From   Maarten buis <maartenbuis@yahoo.co.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: gen & summation again
Date   Tue, 6 Nov 2007 07:28:08 +0000 (GMT)

--- Ziad El-Khatib <Ziad.El-Khatib@ki.se> wrote:
> new query for the summation
> 
> Drug1             Drug2
> --------              -------
> 1                         .
> 3                        .
> .                          1
> 2                          .
> .                           5
> 
> 
> 
> I want to have new variable "drugs" containing the values of drug1
> and drug2 together, but when i make summation, it is generating
> missing values because drug1 and drug2 can not have numerical values
> at the same time, of one obs had data, the other will be empty for
> sure.

egen drug = rowtotal(Drug1 Drug2)

Hope this helps,
Maarten


-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands

visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434

+31 20 5986715

http://home.fsw.vu.nl/m.buis/
-----------------------------------------


      ___________________________________________________________ 
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good  http://uk.promotions.yahoo.com/forgood/environment.html
*
*   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