--- Ziad El-Khatib <[email protected]> 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/
