Hi,
I need to create a summary report for this 3 dataset that have created on this macros.
%macro cnt_inv (tbl=, vr=, table=);
PROC SQL;
create table &tbl. as
select count(*) as &vr. from &table.
where compno in (&complist.) ;
quit;
%mend cnt_inv;
%cnt_inv(tbl=pr_inv_ny_a, vr=prior_wk_inv, table= outf_old);
%cnt_inv(tbl=wrkd_itms_ny_a, vr=worked_inv, table=workeditem);
%cnt_inv(tbl=nw_itms_ny_a, vr=new_items, table=newitem);
Can anyone suggest me..
Thanks in Advance