https://communities.sas.com/t5/SAS-Procedures/number-of-cycles-and-length-of-each-cycle/m-p/68766#M19695 What does your origin dataset look like?<BR /> <BR /> <BR /> Ksharp Tue, 24 May 2011 09:26:38 GMT Ksharp 2011-05-24T09:26:38Z https://communities.sas.com/t5/SAS-Procedures/number-of-cycles-and-length-of-each-cycle/m-p/68765#M19694 How is it possible to determine the number of estrous cycles in dogs when the occurrence of the cycle is given.<BR /> <BR /> For instance, when the determinants of the cycle is given by DI,PR,ES,ME,S,P where DI=diestrus,PR=Proestrus,ES=estrus,ME=metestrus,S=sperm,P=plug. <BR /> <BR /> The occurrence of estrus is only that matters and the cycle is given by EST DI DI DI MET EST -- here the length of the cycle is 5 until the occurrence of next estrus.<BR /> <BR /> A cycle is calculated from one estrus to another estrus. The length of the cycle is the period until next estrus occurs which is 5 in the above case.<BR /> <BR /> How do I write a code to calculate this in Statistics. The endpoint is to calculate the number of cycles and length of each cycle.<BR /> <BR /> The output has to look like this:<BR /> animal_id cycle1 cycle2 cycle3<BR /> 101 5 3 2<BR /> 102 2 3 1<BR /> 103 3 1 2 Mon, 23 May 2011 22:58:36 GMT https://communities.sas.com/t5/SAS-Procedures/number-of-cycles-and-length-of-each-cycle/m-p/68765#M19694 saslover 2011-05-23T22:58:36Z https://communities.sas.com/t5/SAS-Procedures/number-of-cycles-and-length-of-each-cycle/m-p/68766#M19695 What does your origin dataset look like?<BR /> <BR /> <BR /> Ksharp Tue, 24 May 2011 09:26:38 GMT https://communities.sas.com/t5/SAS-Procedures/number-of-cycles-and-length-of-each-cycle/m-p/68766#M19695 Ksharp 2011-05-24T09:26:38Z https://communities.sas.com/t5/SAS-Procedures/number-of-cycles-and-length-of-each-cycle/m-p/68767#M19696 It has many variables. But the variable of interest has observations that look like this<BR /> <BR /> Est<BR /> Di<BR /> Met<BR /> Sp<BR /> Est<BR /> <BR /> and so on Tue, 24 May 2011 09:38:03 GMT https://communities.sas.com/t5/SAS-Procedures/number-of-cycles-and-length-of-each-cycle/m-p/68767#M19696 saslover 2011-05-24T09:38:03Z https://communities.sas.com/t5/SAS-Procedures/number-of-cycles-and-length-of-each-cycle/m-p/68768#M19697 Whether is The following code what you want.<BR /> I have to leave now,Sorry. If you have some problems ,I will be here tomorrow this time.<BR /> <BR /> <BR /> [pre]<BR /> <BR /> <BR /> data temp;<BR /> input id $ x $;<BR /> cards;<BR /> 101 Est<BR /> 101 Di<BR /> 101 Met<BR /> 101 Sp<BR /> 101 Est<BR /> 101 Met<BR /> 101 Sp<BR /> 101 Met<BR /> 101 Est<BR /> 102 Est<BR /> 102 Met<BR /> 102 Sp<BR /> 102 Est<BR /> ;<BR /> run;<BR /> data have;<BR /> set temp;<BR /> if x='Est' then do;<BR /> cycle+1;<BR /> duration=0;<BR /> end;<BR /> if id ne lag(id) then cycle=0;<BR /> duration+1;<BR /> run;<BR /> data _want(keep=id lag_dur cycle_no);<BR /> set have;<BR /> lag_dur=lag(duration);<BR /> if id ne lag(id) then call missing(lag_dur);<BR /> if x='Est' then do;<BR /> cycle_no=cats('cycle',cycle);<BR /> output;<BR /> end;<BR /> run;<BR /> proc transpose data=_want out=want;<BR /> by id;<BR /> id cycle_no;<BR /> var lag_dur;<BR /> run;<BR /> [/pre]<BR /> <BR /> <BR /> Ksharp Tue, 24 May 2011 10:45:22 GMT https://communities.sas.com/t5/SAS-Procedures/number-of-cycles-and-length-of-each-cycle/m-p/68768#M19697 Ksharp 2011-05-24T10:45:22Z