PROC REPORT Not working properly appended dataset

[arunrami]

Dear All,

In the below code, my intention is very simple that I want to report the output table which got generated by PROC APPEND. Its working fine when using proc print but when we are using proc report tool , its generating the sum  of the all the values(all are numeric in existing data set) as a single observation. I am not sure the reason behind this weird behavior of PROC REPORT.

Below attached code and sample output, Please share your thought ....??

%macro report;
%do I=1 %to 2;
proc append base=GDW data=dummy.count&I ;
run; 
%end;
%mend;
%report;

proc print data=GDW;
run;

proc report data=GDW;
column _all_;
run;

[jklaverstijn]

Hi,

What you deem weird is the default behaviour of proc report. Numeric variables are analysis variables and the default statistic is SUM.

If you need different output, read the docs and add statements for grouping and displaying values, subtotalling and/or

statistics. Keep in mind that REPORT is a very powerful procedure but takes some effort to get the output you desire.

Hope this helps,

-- Jan.

[jklaverstijn · Accepted solution]

In case you want to mimic the PROC PRINT output in PROC REPORT you can do this:

proc report data=GDW;
   column _all_;
   define _all_ / display;
run;

This prevents the use of the numeric columns as analysis so there will be no statistic applied, just rows with values will be displayed.

Regards,-- Jan.