Or this:
clear
input str15 Id schlyr new_prc
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
end
g newvar = 1 if new_prc==1
bys Id (schlyr): replace newvar = newvar[_n-1]+1 if newvar !=1
list, noobs
T
On Sat, May 2, 2009 at 2:12 PM, Eva Poen <[email protected]> wrote:
> <>
>
> bys id (sch) : gen princ = sum(new)
> bys id princ (sch) : gen tenure = _n
>
> Hope this helps,
> Eva
>
> 2009/5/1 Meryle Weinstein <[email protected]>
>>
>> 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/
>
> *
> * 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/
>
--
To every ω-consistent recursive class κ of formulae there correspond
recursive class signs r, such that neither v Gen r nor Neg(v Gen r)
belongs to Flg(κ) (where v is the free variable of r).
*
* 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/
