Try: proc sql; create table a as select date, item_no, count(*) as item_no_cnt, sum(sale_qty) as sale_qty_sum, sum(onhand_qty) as onhand_qty_sum from testdataset where date='26mar14'd group by item_no having item_no_cnt>-1 order by item_no_cnt desc; quit;
... View more