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/