Ziad,
. bysort ID (Time) : keep if _n==_N
should do the trick.
However, if you wish to later include some explanatory variables that
vary with time, you should keep all records.
In any case,
. stset Time, id(ID) fail(Event)
will correctly set your data as survival data
Antoine
Ziad El-Khatib wrote:
> Hey again
> I am trying to arrange my dataset to keep one record that has the
> failure event or censor data per patient.
> Any tips about command how to delete the other records prior to
> failure/censor record per patient?
>
> For example
>
> Record nbre ID Time Event
> 1 1001 1 0
> 2 1001 2 0
> 3 1001 3 1
> 4 1002 1 0
> 5 1002 2 1
>
>
> How to be able to take away lines 1,2 and 4?
>
>
> Thank you in advance and best regards
> ziad
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
