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

["Carlo Lazzaro" <carlo.lazzaro@tin.it>]

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/