https://communities.sas.com/t5/SAS-Programming/Counting-subsequent-visits-after-an-index-visit-in-an-episode/m-p/591016#M169252 <P>Hi everyone,</P><P>I am trying to calculate the number of visits in a 14-day episode. All the visits within 14 days of an index visit count as an episode. The index visit is visit #0. The date is in mmddyy format.</P><P>data have -&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;index&nbsp; &nbsp; &nbsp; &nbsp;episode_visits&nbsp; &nbsp; &nbsp; episode_visits_total</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2018&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/2/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/3/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2019&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/18/2019&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>&nbsp;</P><P>My question is, how do I populate the total episode visits when they are 0 (no subsequent visits).</P><P>data want -&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;index&nbsp; &nbsp; &nbsp; &nbsp;episode_visits&nbsp; &nbsp; &nbsp; episode_visits_total</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2018&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/2/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/3/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2019&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/18/2019&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>&nbsp;</P><P>Thank you!!</P> Mon, 23 Sep 2019 18:05:24 GMT skavyasindhu 2019-09-23T18:05:24Z https://communities.sas.com/t5/SAS-Programming/Counting-subsequent-visits-after-an-index-visit-in-an-episode/m-p/591016#M169252 <P>Hi everyone,</P><P>I am trying to calculate the number of visits in a 14-day episode. All the visits within 14 days of an index visit count as an episode. The index visit is visit #0. The date is in mmddyy format.</P><P>data have -&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;index&nbsp; &nbsp; &nbsp; &nbsp;episode_visits&nbsp; &nbsp; &nbsp; episode_visits_total</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2018&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/2/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/3/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2019&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/18/2019&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>&nbsp;</P><P>My question is, how do I populate the total episode visits when they are 0 (no subsequent visits).</P><P>data want -&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;index&nbsp; &nbsp; &nbsp; &nbsp;episode_visits&nbsp; &nbsp; &nbsp; episode_visits_total</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2018&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/2/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/3/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2019&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/18/2019&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>&nbsp;</P><P>Thank you!!</P> Mon, 23 Sep 2019 18:05:24 GMT https://communities.sas.com/t5/SAS-Programming/Counting-subsequent-visits-after-an-index-visit-in-an-episode/m-p/591016#M169252 skavyasindhu 2019-09-23T18:05:24Z https://communities.sas.com/t5/SAS-Programming/Counting-subsequent-visits-after-an-index-visit-in-an-episode/m-p/591207#M169358 <DIV class="lia-message-heading lia-component-message-header"><DIV class="lia-quilt-row lia-quilt-row-standard"><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-left"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"><DIV class="lia-message-subject">&nbsp;</DIV></DIV></DIV><DIV class="lia-quilt-column lia-quilt-column-04 lia-quilt-column-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-message-options"><DIV class="lia-menu-navigation-wrapper lia-menu-action message-menu"><DIV class="lia-menu-navigation"><DIV class="dropdown-default-item">Hi everyone,</DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV><DIV class="lia-message-body"><DIV class="lia-message-body-content"><P>I am trying to calculate the number of visits in a 14-day episode. All the visits within 14 days of an index visit count as an episode. The index visit is visit #0. The date is in mmddyy format.</P><P>data have -&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;index&nbsp; &nbsp; &nbsp; &nbsp;episode_visits&nbsp; &nbsp; &nbsp; episode_visits_total</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2018&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/2/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/3/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2019&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/18/2019&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>&nbsp;</P><P>My question is, how do I populate the total episode visits when they are 0 (no subsequent visits).</P><P>data want -&nbsp;</P><P>ID&nbsp; &nbsp; &nbsp; date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;index&nbsp; &nbsp; &nbsp; &nbsp;episode_visits&nbsp; &nbsp; &nbsp; episode_visits_total</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2018&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/2/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/3/2018&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/1/2019&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;1/18/2019&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>&nbsp;</P><P>Thank you!!</P></DIV></DIV> Tue, 24 Sep 2019 16:01:43 GMT https://communities.sas.com/t5/SAS-Programming/Counting-subsequent-visits-after-an-index-visit-in-an-episode/m-p/591207#M169358 skavyasindhu 2019-09-24T16:01:43Z https://communities.sas.com/t5/SAS-Programming/Counting-subsequent-visits-after-an-index-visit-in-an-episode/m-p/591330#M169359 <P>1. Merged duplicate posts.</P> <P>- It is rude to do this as you are asking people to work for you while possibly duplicating efforts</P> <P>- This question does not belong in Data Management</P> <P>&nbsp;</P> <P>2. You goal in unclear. When are zeros added an when not?</P> Tue, 24 Sep 2019 22:54:12 GMT https://communities.sas.com/t5/SAS-Programming/Counting-subsequent-visits-after-an-index-visit-in-an-episode/m-p/591330#M169359 ChrisNZ 2019-09-24T22:54:12Z