Super! Thanks a lot!
May
May Baydoun, PhD in Epidemiology (UNC-Chapel Hill) Staff Scientist, National Institute on Aging, NIH/IRP, Biomedical Research Center, Baltimore, MD
--- On Tue, 7/14/09, Martin Weiss <[email protected]> wrote:
> From: Martin Weiss <[email protected]>
> Subject: st: AW: summing variables that have similar names
> To: [email protected]
> Date: Tuesday, July 14, 2009, 11:42 AM
>
> <>
>
> -egen, rowtotal()- happily takes a -varlist- so you can do
> anything you see
> in -help varlist-
>
>
> *************
> clear*
>
> inp x1 x2 y z
> 1 . . .
> . 1 . .
> . . 1 .
> . . . 2
> . . 4 .
> . 3 . .
> 4 . . .
> end
> egen sumofxyz=/*
> */ rowtotal(x* y z)
>
> l
> *************
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]]
> Im Auftrag von MAY BAYDOUN
> Gesendet: Dienstag, 14. Juli 2009 17:34
> An: [email protected]
> Betreff: st: summing variables that have similar names
>
> Dear Statalisters,
>
> I was wondering if someone can help me figure out this:
>
> I have several variables that are mutually exclusive. In
> other words, if one
> has a value, the others are missing. I want to sum them
> into a single
> variable so that all observations have a value. They start
> with the same few
> letters, say xyz but have different letters or numbers
> thereafter.
>
> I tried: gen newvar=sum(xyz*) but it didn't work out. Is
> there another way
> to do this? I am guessing a loop?
>
> Thanks a lot for any help you can provide,
>
> Best,
>
> May
>
>
> May Baydoun, PhD in Epidemiology (UNC-Chapel Hill)
> Staff Scientist,
> National Institute on Aging, NIH/IRP, Biomedical
> Research Center,
> Baltimore, MD
>
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
