proc sql; select *,case when count(distinct area_code)>1 then 1 else 0 end as diff_area_code_flag from have group by id; quit; ... View more

Thanks for the suggestion.  It didn't work for my particular purposes but I figured out something that did.  Here's the code in case anyone's interested: proc sql; delete from lib.dataset where varA not between 'value' and 'value' and varB eq value; quit; ... View more