Help using Base SAS procedures

Report

Reply
N/A
Posts: 0

Report

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
Trusted Advisor
Posts: 2,115

Re: Report

Posted in reply to deleted_user
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.
Ask a Question
Discussion stats
  • 1 reply
  • 104 views
  • 0 likes
  • 2 in conversation