or this: data want(drop=flag); do until(last.product); set have; by product; if date = '30sep2015'd and mtd_sales > goal then flag = 1; end; do until(last.product); set have; by product; if flag = 1 then Color = 'GREEN'; else color = 'RED'; output; end; run;
... View more
