topic Re: How to get the start and stop time at recurrent event analysis in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-get-the-start-and-stop-time-at-recurrent-event-analysis/m-p/628166#M185562 <P>Is Date an actual SAS Date value or just a number as posted?</P> Fri, 28 Feb 2020 09:55:09 GMT PeterClemmensen 2020-02-28T09:55:09Z How to get the start and stop time at recurrent event analysis https://communities.sas.com/t5/SAS-Programming/How-to-get-the-start-and-stop-time-at-recurrent-event-analysis/m-p/628163#M185561 <P>Hi there,</P><P>&nbsp;</P><P>I have the dataset "have" that record the state as follow, state=1 means the event happened, zeros otherwise.</P><P>The event&nbsp;may occur more than once over the follow-up time for a given subject.</P><P>I want to calculate the start and stop time for each event to get the dataset "want" as follow.</P><P>For example, the first event (state=0) of ID_1 start at 0 and end at 2.</P><P>&nbsp; &nbsp; Have</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Date</TD><TD>ID</TD><TD>state</TD><TD>count</TD></TR><TR><TD>199801</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>199802</TD><TD>1</TD><TD>0</TD><TD>2</TD></TR><TR><TD>199803</TD><TD>1</TD><TD>1</TD><TD>3</TD></TR><TR><TD>199804</TD><TD>1</TD><TD>1</TD><TD>4</TD></TR><TR><TD>199805</TD><TD>1</TD><TD>1</TD><TD>5</TD></TR><TR><TD>199806</TD><TD>1</TD><TD>0</TD><TD>6</TD></TR><TR><TD>199801</TD><TD>2</TD><TD>0</TD><TD>1</TD></TR><TR><TD>199802</TD><TD>2</TD><TD>0</TD><TD>2</TD></TR><TR><TD>199803</TD><TD>2</TD><TD>1</TD><TD>3</TD></TR><TR><TD>199804</TD><TD>2</TD><TD>1</TD><TD>4</TD></TR><TR><TD>199805</TD><TD>2</TD><TD>0</TD><TD>5</TD></TR><TR><TD>199806</TD><TD>2</TD><TD>0</TD><TD>6</TD></TR><TR><TD>199807</TD><TD>2</TD><TD>0</TD><TD>7</TD></TR><TR><TD>199808</TD><TD>2</TD><TD>0</TD><TD>8</TD></TR><TR><TD>199809</TD><TD>2</TD><TD>1</TD><TD>9</TD></TR><TR><TD>1998010</TD><TD>2</TD><TD>1</TD><TD>10</TD></TR><TR><TD>1998011</TD><TD>2</TD><TD>0</TD><TD>11</TD></TR><TR><TD>1998012</TD><TD>2</TD><TD>0</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to get the start and stop time of each event for each subject. And the "Newdate" is following the start time as follow.<BR />Want</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>NewDate</TD><TD>ID</TD><TD>start</TD><TD>stop</TD><TD>state</TD></TR><TR><TD>199712</TD><TD>1</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>199802</TD><TD>1</TD><TD>2</TD><TD>5</TD><TD>1</TD></TR><TR><TD>199805</TD><TD>1</TD><TD>5</TD><TD>6</TD><TD>0</TD></TR><TR><TD>199712</TD><TD>2</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>199802</TD><TD>2</TD><TD>2</TD><TD>4</TD><TD>1</TD></TR><TR><TD>199804</TD><TD>2</TD><TD>4</TD><TD>8</TD><TD>0</TD></TR><TR><TD>199808</TD><TD>2</TD><TD>8</TD><TD>10</TD><TD>1</TD></TR><TR><TD>199810</TD><TD>2</TD><TD>10</TD><TD>12</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>data ISA.Have;<BR />infile datalines missover;<BR />input Date ID state count;<BR />label ID='Subject ID';<BR />datalines;<BR />199801 1 0 1<BR />199802 1 0 2<BR />199803 1 1 3<BR />199804 1 1 4<BR />199805 1 1 5<BR />199806 1 0 6<BR />199801 2 0 1<BR />199802 2 0 2<BR />199803 2 1 3<BR />199804 2 1 4<BR />199805 2 0 5<BR />199806 2 0 6<BR />199807 2 0 7<BR />199808 2 0 8<BR />199809 2 1 9<BR />1998010 2 1 10<BR />1998011 2 0 11<BR />1998012 2 0 12<BR />;</P><P>Many thanks.</P><P>&nbsp;</P><P>Regards,</P><P>Hui</P> Fri, 28 Feb 2020 09:49:31 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-the-start-and-stop-time-at-recurrent-event-analysis/m-p/628163#M185561 Maomao_Hui 2020-02-28T09:49:31Z Re: How to get the start and stop time at recurrent event analysis https://communities.sas.com/t5/SAS-Programming/How-to-get-the-start-and-stop-time-at-recurrent-event-analysis/m-p/628166#M185562 <P>Is Date an actual SAS Date value or just a number as posted?</P> Fri, 28 Feb 2020 09:55:09 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-the-start-and-stop-time-at-recurrent-event-analysis/m-p/628166#M185562 PeterClemmensen 2020-02-28T09:55:09Z Re: How to get the start and stop time at recurrent event analysis https://communities.sas.com/t5/SAS-Programming/How-to-get-the-start-and-stop-time-at-recurrent-event-analysis/m-p/628169#M185563 <P>Also, a few of your date values have the form&nbsp;1998010 ?</P> <P>&nbsp;</P> <P>Is this an error or something we should account for?</P> Fri, 28 Feb 2020 10:01:27 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-the-start-and-stop-time-at-recurrent-event-analysis/m-p/628169#M185563 PeterClemmensen 2020-02-28T10:01:27Z