Statalist The Stata Listserver


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

Re: st: Count variable


From   n j cox <n.j.cox@durham.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Count variable
Date   Mon, 19 Mar 2007 16:11:41 +0000

Try

bysort id office (electionyear) : gen count = 0

by id office : replace count =
	cond(_n == 1, 1, 1 + count[_n-1]) + 1 if win


Felipe Botero, modulo a mass of MIME/HTML, asked

I have data on congressional careers and need to create a variable that
counts the number of *consecutive* terms served in the same office.


I used the following code but it didn't do the trick:

sort id office electionyear

by id office: gen count = cond(win==0,0,sum(win))

list id office win count

  +---------------------------------+

  |  id   office    win       count |

  |---------------------------------|

  | 153          1     0          0 |
  | 153          1     1          1 |
  | 153          1     0          0 |
  | 153          1     1          2 |  <-- should start again with 1
  | 153          1     1          3 |
  | 153          1     1          4 |
  +---------------------------------+

The problem is that I need the counter to start back at 1 after each
occurrence of win==0.


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