Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Nick Cox <njcoxstata@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: RE: creating group property in a panel data |
Date | Thu, 26 Apr 2012 02:00:02 +0100 |
My typo. I mixed names. You want . gen both = ever_alcohol!=ever_nonalcohol On Wed, Apr 25, 2012 at 9:39 PM, Caliph Omar Moumin <sheikmoumin@yahoo.com> wrote: > Thx Nick for ur quick reply. > > Yes it seems exactly like you indicated below. > > > Nr groupdiag > > 123 0 > 123 0 > 123 1 > > 234 0 > 234 0 > 234 0 > > 345 1 > 345 1 > > > When i tried to apply your instruction, > > the last command which is > > gen both = is_alc != is_nonalc > > does not execute. I do not know if this solves my problem or not > > in my dataset it looks like this > > egen ever_alcohol = max(groupdaig), by(Nr) > > . egen ever_nonalcohol = min(groupdaig), by(Nr) > > . gen both = is_alcohol!=is_nonalcohol > > stata error > is_alcohol not found > r(111); > > I would appreciate if you could help? > > > > > Kind Regards, > Moumin > > Email: sheikmoumin@yahoo.com > > > > ----- Original Message ----- > From: Nick Cox <n.j.cox@durham.ac.uk> > To: "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu> > Cc: > Sent: Wednesday, April 25, 2012 7:28 PM > Subject: st: RE: creating group property in a panel data > > It seems that you have something like this: > > id diagnosis > > 123 0 > 123 0 > 123 1 > > 234 0 > 234 0 > 234 0 > > 345 1 > 345 1 > > And you are interested in classifying patients. > > If you go > > egen ever_alc = max(diagnosis) , by(id) > egen ever_nonalc = min(diagnosis) , by(id) > gen both = is_alc != is_nonalc > > you may get something relevant. Otherwise I think we need to see a clear example, as your word description is a bit fuzzy. > > Nick > n.j.cox@durham.ac.uk > > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Caliph Omar Moumin > Sent: 25 April 2012 18:16 > To: statalist@hsphsun2.harvard.edu > Subject: st: creating group property in a panel data > > dear statlist > > My panel data is patient registry of one year which includes variable ID, and variable daignosis. I group classified daignosis into two groups > those related to alcohol and those not related to alcohol. > > so a varaible name called groupdaig is created with 0 for non-related to alcohol and 1 = for related to alcohol. That was so far good. > > since my data is a panel data same observation in the ID variable is included in both non-alcohol related daignosis and the alcohol related diagnosis. > > How can i make unique property, or code to this group? the observatios (patients) which are treated both alcohol and non-alcohol related daignosis? > > I tried to apply this > http://www.stata.com/support/faqs/data/members.html > > but i didn't fit to my data structure. > > > Kind Regards, > Moumin > > Email: sheikmoumin@yahoo.com > > > * > * 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/ * * 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/