https://communities.sas.com/t5/SAS-Programming/How-to-delete-observations-with-a-date-that-is-outside-a-week-of/m-p/819080#M323329 <P>Hello, I need to delete observations that have an activity session outside of 1 week from admit or discharge.&nbsp; My data look like the following:</P><P>(ID=subject, adate= admission date, ddate= discharge date, actdate= activity session date)</P><P>&nbsp;</P><P>ID&nbsp; &nbsp;adate&nbsp; &nbsp; &nbsp; &nbsp; ddate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; actdate</P><P>1&nbsp; &nbsp; 1/3/2021&nbsp; &nbsp;1/30/2021&nbsp; &nbsp;1/11/2021</P><P>1&nbsp; &nbsp; 1/3/2021&nbsp; &nbsp;1/30/2021&nbsp; &nbsp;1/9/2021</P><P>2&nbsp; &nbsp; 1/4/2021&nbsp; &nbsp;1/29/2021&nbsp; &nbsp;1/28/2021</P><P>2&nbsp; &nbsp; 1/4/2021&nbsp; &nbsp;1/29/2021&nbsp; &nbsp;1/15/2021</P><P>&nbsp;</P><P>What I want:</P><P>&nbsp;</P><P>ID&nbsp; &nbsp;adate&nbsp; &nbsp; &nbsp; &nbsp; ddate&nbsp; &nbsp; &nbsp; &nbsp; actdate</P><P>1&nbsp; &nbsp; 1/3/2021&nbsp; &nbsp;1/30/2021&nbsp; &nbsp;1/9/2021</P><P>2&nbsp; &nbsp; 1/4/2021&nbsp; &nbsp;1/29/2021&nbsp; &nbsp;1/28/2021</P><P>&nbsp;</P><P>&nbsp;</P><P>Thank you!</P> Mon, 20 Jun 2022 00:05:47 GMT eclaire 2022-06-20T00:05:47Z https://communities.sas.com/t5/SAS-Programming/How-to-delete-observations-with-a-date-that-is-outside-a-week-of/m-p/819080#M323329 <P>Hello, I need to delete observations that have an activity session outside of 1 week from admit or discharge.&nbsp; My data look like the following:</P><P>(ID=subject, adate= admission date, ddate= discharge date, actdate= activity session date)</P><P>&nbsp;</P><P>ID&nbsp; &nbsp;adate&nbsp; &nbsp; &nbsp; &nbsp; ddate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; actdate</P><P>1&nbsp; &nbsp; 1/3/2021&nbsp; &nbsp;1/30/2021&nbsp; &nbsp;1/11/2021</P><P>1&nbsp; &nbsp; 1/3/2021&nbsp; &nbsp;1/30/2021&nbsp; &nbsp;1/9/2021</P><P>2&nbsp; &nbsp; 1/4/2021&nbsp; &nbsp;1/29/2021&nbsp; &nbsp;1/28/2021</P><P>2&nbsp; &nbsp; 1/4/2021&nbsp; &nbsp;1/29/2021&nbsp; &nbsp;1/15/2021</P><P>&nbsp;</P><P>What I want:</P><P>&nbsp;</P><P>ID&nbsp; &nbsp;adate&nbsp; &nbsp; &nbsp; &nbsp; ddate&nbsp; &nbsp; &nbsp; &nbsp; actdate</P><P>1&nbsp; &nbsp; 1/3/2021&nbsp; &nbsp;1/30/2021&nbsp; &nbsp;1/9/2021</P><P>2&nbsp; &nbsp; 1/4/2021&nbsp; &nbsp;1/29/2021&nbsp; &nbsp;1/28/2021</P><P>&nbsp;</P><P>&nbsp;</P><P>Thank you!</P> Mon, 20 Jun 2022 00:05:47 GMT https://communities.sas.com/t5/SAS-Programming/How-to-delete-observations-with-a-date-that-is-outside-a-week-of/m-p/819080#M323329 eclaire 2022-06-20T00:05:47Z https://communities.sas.com/t5/SAS-Programming/How-to-delete-observations-with-a-date-that-is-outside-a-week-of/m-p/819103#M323342 <P>No observation satisfies your condition, as in all either the adate or the ddate are more than one week from actdate.</P> <P>&nbsp;</P> <P>Or did you mean: actdate must be between one week before adate and one week after ddate?</P> Mon, 20 Jun 2022 07:03:34 GMT https://communities.sas.com/t5/SAS-Programming/How-to-delete-observations-with-a-date-that-is-outside-a-week-of/m-p/819103#M323342 Kurt_Bremser 2022-06-20T07:03:34Z