Re: st: RE: creating group property in a panel data

[Caliph Omar Moumin <sheikmoumin@yahoo.com>]

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/