# Re: st: counting events

 From n j cox To statalist@hsphsun2.harvard.edu Subject Re: st: counting events Date Wed, 07 Feb 2007 23:11:44 +0000

```I can't see details on died or not died here.
I guess everybody in the dataset died.

On one question, you want the number of distinct incidents.
This is given by

tab incident
di r(r)

or by

ssc inst distinct
distinct incident

How do I compute the number of distinct observations?
http://www.stata.com/support/faqs/data/distinct.html

On another question, you want to label distinct incidents, 1 up.

This is

egen event = group(incident)

How do I create individual identifiers numbered from 1 upwards?
http://www.stata.com/support/faqs/data/group.html

(Incidentally, for me,

sort incident count
by incident : gen event = _n

does not do what you report.)

Nick
n.j.cox@durham.ac.uk

Ana Gabriela Guerrero Serdan

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.

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