RE: st: combine 2 variables

[Dao Kim <Kim.Dao@chuv.ch>]

Id 101 to 175 identifies the patients

-----Message d'origine-----
De : owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] De la part de Dao Kim
Envoyé : mardi 11 février 2014 21:51
À : 'statalist@hsphsun2.harvard.edu'
Objet : RE: st: combine 2 variables

Hi Nick, dg1 and dg2 are string variables, all the same (hemorrhage, stroke, asphyxia, malformative, infectious, others), I converted them into numeric variables. Each ID has at least 1 diagnosis (dg1), only 5 have a 2nd diagnosis (dg2). In order to analyse diagnoses as a whole. Thanks Here is the description

. describe cat_dg1 cat_dg2



              storage   display    value

variable name   type    format     label      variable label

------------------------------------------------------------------------------------------------------------------------------------------

cat_dg1         long    %12.0g     cat_dg1    

cat_dg2         long    %12.0g     cat_dg2    



. list cat_dg1 cat_dg2 in 1/10



     +----------------------+

     |    cat_dg1   cat_dg2 |

     |----------------------|

  1. | hemorrhage         . |

  2. |   asphyxic         . |

  3. | hemorrhage         . |

  4. |     stroke         . |

  5. |     others         . |

     |----------------------|

  6. | hemorrhage         . |

  7. |   asphyxic         . |

  8. |     others         . |

  9. | hemorrhage         . |

 10. |   asphyxic         . |

     +----------------------+



-----Message d'origine-----
De : owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] De la part de Nick Cox Envoyé : mardi 11 février 2014 20:28 À : statalist@hsphsun2.harvard.edu Objet : Re: st: combine 2 variables

Thanks, but we (I) still don't know what your variable types and values are, exactly.

Please show the results of

. describe dg1 dg2

. list dg1 dg2 in 1/10

Also add to the variables above whatever identifies your patients.
(Use anonymous equivalents by all means if confidentiality is an
issue.)

Also, show what a new variable should look like.

Nick
njcoxstata@gmail.com


On 11 February 2014 19:22, Dao Kim <Kim.Dao@chuv.ch> wrote:
> Most of my patients have 1 diagnosis: ie hemorrhage, asphyxia or 
> stroke (variable dg1) Some have 2: hemorrhage and asphyxia (another variable dg2); is it possible to associate these two as only one variable for one patient? I am trying to evaluate the efficacy of a drug according to the diagnosis, there are so few patients with 2 diagnoses (dg2) that it doesn't make sense to use it isolated.  it does this make more sense?
>
> -----Message d'origine-----
> De : owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] De la part de Nick Cox 
> Envoyé : mardi 11 février 2014 20:07 À :
> statalist@hsphsun2.harvard.edu Objet : Re: st: combine 2 variables
>
> Dao Kim:
>
> This is incomprehensible.
>
> "combine": what does that mean?
>
> "Concat" doesn't work. I guess that you tried -egen, concat()- but what exactly did you try? What do you mean by "doesn't work"?  What did it do? Why isn't that what you want?
>
> "merge 1:1 id"  -merge- is for merging two or more datasets. That is a completely different problem from combining two variables.
>
> But forget all that.
>
> What are your variables?
>
> What are your observations?
>
> Please show us an example of your data.
>
> Please show us an example of what you want to get.
>
>
> Nick
> njcoxstata@gmail.com
>
>
> On 11 February 2014 18:59, Dao Kim <Kim.Dao@chuv.ch> wrote:
>> Dear Statalists, I try to combine two diagnoses variables to one, for patients that mostly only have 1 diagnosis for seizures etiology, but a minority has 2 etiologies/diagnoses, I can't figure out how to make only one variable. Concat doesn't work, I tried to merge 1:1 id , any idea? Thanks for your help!
>>
>> *
>> *   For searches and help try:
>> *   http://www.stata.com/help.cgi?search
>> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/