Thank you Ballardw for your reply.
Yes I did simplify my example. In fact, I have multiple measurements...measurement1...measurement2...etc, each with a min and max value. I have written code that finds each row that has an outlier value, and assigns a 1.
DOBID Measurement Measurement2 Outlier (1=yes)
1 10 12 0
1 20 13 0
2 12 6 1
2 17 18 0
3 22 19 1
3 18 15 0
In this example 22 and 6 are outliers, so DOBID 2 and 3 should be excluded (all measurements).
So using your reasoning, something like this? Unless there is a better method? I've never used proc sql before...
/* get a maximum value for each id*/ proc summary data=have nway; class dobid; var outlier; output out= temp max=; run; proc sql; create table want as select b.* from temp as left join have as b on a.dobid=b.dobid where a.outlier lt 1; quit;
... View more