I have a dataset that is set up as
Id schlyr new_pr~c
A 1 1
A 2 0
A 3 0
A 4 0
A 5 0
A 6 0
A 7 0
A 8 0
A 9 0
A 10 0
A 11 0
B 1 1
B 2 0
B 3 0
B 4 0
B 5 0
B 6 0
B 7 0
B 8 0
B 9 0
B 10 1
B 11 0
Etc.
I want to create a new variable that is the number of years of principal
tenure at each school based on the schoolyear and newprinc. The counter
should start again at 1 if new principal is 1 and go for the number of years
until the new principal.
Can't figure out the correct syntax to do this. Any help is appreciated.
Meryle Weinstein, Ph.D.
Assistant Director
Institute for Education & Social Policy
New York University
82 Washington Square East, 7th floor
New York, NY 10003
(212) 9985817
(212) 9954564 (fax)
www.steinhardt.nyu.edu/iesp
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
