Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
"Carlo Lazzaro" <carlo.lazzaro@tin.it> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
st: R: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000 |

Date |
Mon, 26 Sep 2011 11:51:13 +0200 |

Dear Georges, in your example, the solution I proposed is surely very time consuming. However, I assume that patients in your dataset are ordered in progressive order of imputation for each hospital participating in your research. I mean something like Hosp_1_1; Hosp_1_2;...;Hosp_2_1; Hosp_2_2 and so forth, where the first number refers to hospital and the second one identifies the patient. Let's call this variable pts_code. You can type - sort pts-code - and hospital should appear in alphabetical order (with patients progressively identifies via the second number of pts_code. Then you can create another variable (let's call it hsp_cluster) in this way: g hsp_cluster= 1 in 1/84 //** assuming you have the same number of patients enrolled in each one of the 36 hospitals you mention replace hsp_cluster=2 in 85/169 and so forth, until you reach the 36th cluster. I would agree that this solution too is time consuming. Unfortunately, this is the price we have to pay whenever we omit the centre_code variable in data input. I do hope this helps. Kindest Regards, Carlo -----Messaggio originale----- Da: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Per conto di COMPAORE Georges Inviato: lunedì 26 settembre 2011 11.04 A: statalist@hsphsun2.harvard.edu Oggetto: st: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000 Dear Carlo, In my situation there are almost 3000 patients for 36 hospitals (36 clusters?). It will be time consuming to apply this solution, will not it? Georges -----Message d'origine----- De : owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] De la part de Carlo Lazzaro Envoyé : samedi 24 septembre 2011 16:13 À : statalist@hsphsun2.harvard.edu Cc : 'COMPAORE Georges' Objet : st: R: Date: Fri, 23 Sep 2011 16:11:35 -0000 Dear Gorge, you are right. The example I sketched considers 10 patients (5 from an hypothetical hospital in Rome and 5 from an hypothetical hospital in Milan) and 2 clusters, ie the two hospitals. HTH and Kindest Regards, Carlo -----Messaggio originale----- Da: COMPAORE Georges [mailto:georgesday@yahoo.fr] Inviato: sabato 24 settembre 2011 13.00 A: statalist@hsphsun2.harvard.edu Cc: 'Carlo Lazzaro' Oggetto: RE: Date: Fri, 23 Sep 2011 16:11:35 -0000 Dear Carlo, I need some clarification about your solution. Should I understand that in your example there are 10 observations about patients and the number of clusters is 2. Best regards -----Message d'origine----- De : Carlo Lazzaro [mailto:carlo.lazzaro@tin.it] Envoyé : samedi 24 septembre 2011 09:36 À : statalist@hsphsun2.harvard.edu Cc : 'COMPAORE Georges' Objet : R: Date: Fri, 23 Sep 2011 16:11:35 -0000 Dear Gorge, the following code might do what you are asking for: ---------------------------------------------------- set obs 10 g id=_n g pts_code="Rome_1" in 1 replace pts_code="Rome_2" in 2 replace pts_code="Rome_3" in 3 replace pts_code="Rome_4" in 4 replace pts_code="Rome_5" in 5 replace pts_code="Milan_1" in 6 replace pts_code="Milan_2" in 7 replace pts_code="Milan_3" in 8 replace pts_code="Milan_4" in 9 replace pts_code="Milan_5" in 10 g cluster=1 in 1/5 replace cluster=2 in 6/10 ---------------------------------------------------- Kindest Regards, Carlo -----Messaggio originale----- Da: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Per conto di COMPAORE Georges Inviato: venerdì 23 settembre 2011 18.12 A: statalist@hsphsun2.harvard.edu Oggetto: st: Date: Fri, 23 Sep 2011 16:11:35 -0000 Hello Statalist users, I need your help on the following issue: I want to know how to transform a simple database (example: patients database) to cluster database (example: Hospital database). Georges * * 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/

**Follow-Ups**:**Re: st: R: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000***From:*Nick Cox <njcoxstata@gmail.com>

**References**:**st: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000***From:*"COMPAORE Georges" <georgesday@yahoo.fr>

- Prev by Date:
**st: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000** - Next by Date:
**Re: st: R: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000** - Previous by thread:
**st: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000** - Next by thread:
**Re: st: R: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000** - Index(es):