Hey guys, I am new to SAS. I have a problem which looks like the following. There are two types of visits, x and y. The data has already sorted based on id and visit date. Now I want to exclude all the x type visits for each id number. Also, if the visit date of y type falls in the range of x's check in and check out date, it also needs to be excluded. Moreover, if there is an x type visit in 3 days after y type visit, both of them need to be excluded. Can someone please help??? This is how the raw data look like: id visit date check in check out type 1 1/29/19 1/23/19 1/29/19 x 1 1/26/19 y 2 2/1/19 y 2 2/2/19 2/2/19 2/6/19 x 3 3/3/19 3/5/19 3/20/19 x 3 3/5/19 3/5/19 3/20/19 y 4 4/23/19 4/24/19 4/27/19 x 4 4/24/19 4/24/19 4/27/19 y 4 8/8/19 y 5 9/1/19 y 5 9/4/19 9/4/19 9/6/19 x 5 10/10/19 10/10/19 10/21/19 y This is how the result should be: id visit date check in check out type 4 8/8/19 y 5 10/10/19 10/10/19 10/21/19 y
... View more