Hi SAS experts, I have a dataset that shows something like this: data SASHELP.SAMPLE;
infile datalines dsd truncover;
input DATE:DDMMYY10. PERSON:$4. TASK:$4.;
format DATE date9.;
datalines4;
01/01/2017,1000,AB
01/01/2017,1000,ABC
01/01/2017,1111,ABCD
01/01/2017,1111,ABC
01/01/2017,2111,ABCD
08/01/2017,1000,XY
08/01/2017,2111,ABC
08/01/2017,2111,XYZ
15/01/2017,1000,ABC
15/01/2017,1000,ABCD
15/01/2017,1000,AA
22/01/2017,1111,ABC
22/01/2017,1000,ABC
;;;; What I'm basically looking for, is to identify PERSONs that have recorded an observation in each of the 4 dates that I have. So as we can see from the dataset above, only PERSON="1000" satisfies my requirement. So I want my eventual dataset to only contain PERSONs that meets the requirement. data SASHELP.WANT;
infile datalines dsd truncover;
input DATE:DDMMYY10. PERSON:$4. TASK:$4.;
format DATE date9.;
datalines4;
01/01/2017,1000,AB
01/01/2017,1000,ABC
08/01/2017,1000,XY
15/01/2017,1000,ABC
15/01/2017,1000,ABCD
15/01/2017,1000,AA
22/01/2017,1000,ABC
;;;;
... View more