Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: counting events


From   n j cox <n.j.cox@durham.ac.uk>
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

See also
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)

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

In short, the FAQs are friendly answers to your questions.

(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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index