Dear SAS community, I am having the following problem: My dataset has 3 variables: date, sample, episode. Now I want to reduce the dataset so that I only have the episodes when a sample was taken. A definition of an episode is that there are 3 days before and after without an Episode (E=0). So in the following example I only want the data from 05/01-09/01 because this will be my episode for the sample that was taken on 05/01/20. There is one day which is not qualifying for E=1 but that doesnt matter because it is within the episode. I hope it is somehow clear what I mean. Thank you in advance for your help. Bianca data WORK.CLASS; input date sample episode; datalines; 010120 0 0 020120 0 0 030120 0 0 040120 0 0 050120 1 1 060120 0 1 070120 0 1 080120 0 0 090120 0 1 100120 0 0 110120 0 0 120120 0 0 130120 0 0 run;
... View more