Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


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

st: Recording episodes


From   "Michael Ghebre" <[email protected]>
To   <[email protected]>
Subject   st: Recording episodes
Date   Wed, 6 Jul 2011 18:23:10 +0100

Dear All

I have 1000 subjects (two treatment groups) and about 200 visits for
individual subject and recorded their diarrhea [0= no diarrhea and 1=
diarrhea]. 

I want to record episodes of diarrhea as 1 (episodes=1) if there is series
of diarrhea; and if there is 2 or more diarrhea-free days (diarrhea = 0)
after a diarrhea days and the next days with diarrhea (diarrhea=1), recorded
as second episode of diarrhea (episode=1). Example in the table below, 

I want to write stata code which could help me recording the episodes based
on the sequence of diarrhea.

+-------------------------------------+
     | subjId   visit   diarrhea   episode |
     |-------------------------------------|
  1. |      1       1          0         0 |
  2. |      1       2          1         1 |
  3. |      1       3          1         0 |
  4. |      1       4          0         0 |
  5. |      1       5          0         0 |
  6. |      1       6          1         1 |
  7. |      1       7          1         0 |
  8. |      1       8          0         0 |
  9. |      1       9          1         0 |
 10. |      1      10          1         0 |
 11. |      .       .          .         . |
 12. |      .       .          .         . |
 13. |      .       .          .         . |
     |-------------------------------------| 
 14. |      2       1          1         1 |
 15. |      2       2          1         0 |
 16. |      2       3          1         0 |
 17. |      2       4          0         0 |
 18. |      2       5          1         0 |
 19. |      2       6          0         0 |
 20. |      2       7          0         0 |
 21. |      2       8          0         0 |
 22. |      2       9          1         1 |
 23. |      2      10          0         0 |
 24. |      2      11          0         0 |
 25. |      2      12          1         1 |
 26. |      2      13          1         0 |
 27. |      2      14          1         0 |
 28. |      2      15          1         0 |
 29. |      2      16          0         0 |
 30. |      .       .          .         . |
 31. |      .       .          .         . |
 32. |      .       .          .         . |
 


I would highly appreciate your help!

Thanks 
Michael

*
*   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–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index