Try this one... %macro test; proc sql; select count(distinct fee) into :fees_group from test; quit; proc sql; create table test as select calendar_day,order_status,fee,sum(no) as total from total group by 1,2,3; quit; %if %eval(&fees_group. EQ 0) %then %do; proc sql; insert into test set calendar_day = 1/8/2013, order_status = "start", fee = "Free", total = .; quit; %end; %mend test; %test;
... View more
