【sas sql proc】where or having

having作用类似于where区别在于where在group by之前执行；having作用于group by。

proc sql;
    select sum(cmcc_fee) as sumfee,product_name,port
    from &groupset
    group by product_name,port
    having count(port)>2;
quit;