st: Count variable

[Felipe Botero <fbotero@uniandes.edu.co>]

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.

 

Any ideas on how to do this?

 

Thanks,

 

 

 

------------------------------------------------------------

Felipe Botero
Profesor Asistente
Departamento de Ciencia Pol�tica

Universidad de los Andes

Bogot�, Colombia
Tel: +57(1) 339 4949 x 2615
fbotero@uniandes.edu.co
http://wwwprof.uniandes.edu.co/~fbotero
------------------------------------------------------------