HI,
I am struggling on the following. I need to count the
events or number of incidents where people died. I
have information at the individual level such as:
+----------------------------+
| count incident sex |
|----------------------------|
1. | 1 x007 unknown |
2. | 2 x038 male |
3. | 3 x038 male |
4. | 4 x038 male |
5. | 5 k000 female |
|----------------------------|
6. | 6 k000 unknown |
7. | 7 x038 unknown |
8. | 8 x038 unknown |
9. | 9 x035 unknown |
10. | 10 x040 unknown |
I am trying to generate a new variable call "event"
that will put a number to each same incident
like: incident x007 event 1
incident x038 event 2
incident k000 event 3
etc..
I tried using:
sort incident count
by incident: gen event = _n
but it gives only values to 1 to the first event and 0
to the rest.
Any ideas how to solve this?
thanks,
*
* 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/
