I actually like PG's better, but here's a similar approach using a case instead. proc sql; create table test as select g, x, case           when count(x)=1 then 2           when min(x)=x then 1           else 0 end as min_x_by_g from min_ex group by g; quit; ... View more