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 |
R: st: R: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000 |

Date |
Mon, 26 Sep 2011 12:10:56 +0200 |

Dear Nick, thanks a lot for chiming in. As usual, very helpful. Kindest Regards, Carlo -----Messaggio originale----- Da: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Per conto di Nick Cox Inviato: lunedì 26 settembre 2011 12.06 A: statalist@hsphsun2.harvard.edu Oggetto: Re: st: R: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000 I don't understand this exchange. Georges has what is still an extremely vague question. In the absence of any detail about his data -- what the variables are, what typical observations look like, etc. -- just about the only recommendation that will cover his problem is to read the Data management manual until the answer becomes clear. Georges: You really need to tell us more. Carlo appears to be trying to guess what Georges' data might look like. But even in the situations he imagines it is definitely not necessary to use a command for each group specifying -in <range>- after a look at the data. For example, in the data of Carlo's first posting split pts_code, parse(_) which separate out hospital and patient identifiers. Carlo's trying very hard to help, but the real difficulty is that Georges' precise problem remains clear. Nick On Mon, Sep 26, 2011 at 10:51 AM, Carlo Lazzaro <carlo.lazzaro@tin.it> wrote: > 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. COMPAORE Georges > 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? Carlo Lazzaro > 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. COMPAORE Georges > 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. Carlo Lazzaro [mailto:carlo.lazzaro@tin.it] > 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 COMPAORE Georges > 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). * * 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/

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

- Prev by Date:
**Re: st: R: RE: R: Date: Fri, 23 Sep 2011 16:11:35 -0000** - Next by Date:
**st: Does anyone know how to do mi predict in Stata 11** - Previous by thread:
**Re: st: R: 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):