data have; input PID     Event     VAR; datalines; 1923     1          0 1923     1         .02 1923     1         .03 1923     1         .04 1923     1         .002 1923     1          0 2003     1          0 2003     1         .02 2003     1         .06 2003     1         .07 2003     1         .003 2003     1          0 ; proc sql; select * from have group by pid,event having sum(var>=0.02)>=3; quit; ... View more

Here's another approach: data want; set have (rename=(var=varx)); by pid event; retain var; if first.event then var = .; var = coalesce( var, varx ); if last.event then output; drop varx; run; ... View more

"Is there something in particular that is supposed to go into the parentheses? Same thing with this line: if h.check()=0;" Yes. there are some parameters in it. You need to check it in sas documentation( dictionary ). "Does this code select the max value and the value on either side of the max value? " Yes. include if there were multiple maximum value . ' if I wanted to also select the minimum value, would I just added value=min(value);?" Yes.If you also want to do it like maximum did . Xia Keshan ... View more