Statalist


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

Re: st: RE: Gap in treatment


From   Gary Walker <garywalk@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Gap in treatment
Date   Sat, 11 Jul 2009 15:20:55 -0700

Actually I forgot I converted the dates before importing into stata.
Now it is like this:

 Patient     days chemo drug
 A          45           X
 A         6745         Y
 A          645          X
 B          345          Z
 B          343          X
 C          5667        Y
 C          123          X
 C          5              Z


When I try:
sort patient days

it is not in the correct order.  it lists them like this:

101
178
201
255
13
54
78

Why is it not sorting them correctly?



On Sat, Jul 11, 2009 at 3:11 PM, PEREZ PEREZ JORGE
EDUARDO<perez.jorge@ur.edu.co> wrote:
> Make sure your date has the proper format (i.e %td), then:
>
> sort patient date
> by patient: gen gap=date[_n]-date[_n-1]
> by patient: egen maxgap=max(gap)
>
> Hope this helps,
> _________________________
> Jorge Eduardo Pérez Pérez
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Gary Walker
> Sent: sábado, 11 de julio de 2009 04:45 p.m.
> To: statalist@hsphsun2.harvard.edu
> Subject: st: Gap in treatment
>
> I have a dataset of each administration of chemotherapy for a number
> of patients, i.e.:
>
> Patient     date      chemo drug
> A          7/1/2009    X
> A         4/1/2009    Y
> A          1/1/2008    X
> B          7/1/2009    Z
> B          1/1/2008    X
> C          7/1/2009    Y
> C          4/1/2009    X
> C          1/1/2008    Z
>
> I want to calculate the biggest gap in treatment for each patient. In
> other words, what was the maximum amount of time between treatments
> for each patients.  Any ideas on how to do this?
> *
> *   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/
>



-- 
Gary Walker

*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index