Report

[deleted_user]

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

[Doc_Duke]

Combine the three tables into one and then use one of the mulititude of SAS reporting tools (PRINT, REPORT, TABULATE, even the DATA step). PROC PRINT can list the data. You've only got 3 numbers, so it is unclear what you are really trying to do.

You can search the SAS web site for documentation and BBUs about each of the tools.