topic Re: Add total Row using Proc Report in SAS Programming

Add total Row using Proc Report

sascode — Fri, 21 Oct 2022 15:34:28 GMT

Hello,

I have dataset as follows:
data have;
input binary Count Percent ;
datelines;
0 70 70
1 30 30
;
run;

I would like to add a total row using proc report and to display as follows :
binary Count Percent

0 70 70
1 30 30

Total 100 100

Thank you.

Re: Add total Row using Proc Report

PaigeMiller — Fri, 21 Oct 2022 15:42:13 GMT

Use

rbreak after

as shown in this example: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/p1ai2km76blvcvn12ye0q6i3187a.htm

Re: Add total Row using Proc Report

sascode — Fri, 21 Oct 2022 15:59:37 GMT

PROC REPORT DATA = have;
columns binary COUNT PERCENT ;
define binary/ display ;
define COUNT/ analysis sum;
define PERCENT/ analysis sum;
rbreak after /summarize ;
compute after;
binary = 'Total';
endcomp;
RUN;

does not print the word "Total" , it displays it as missing.
Thank you.

Re: Add total Row using Proc Report

PaigeMiller — Fri, 21 Oct 2022 16:01:53 GMT

Please follow this example from @Ksharp

https://communities.sas.com/t5/SAS-Programming/PROC-REPORT-can-you-place-descriptive-text-in-a-BREAK-or-RBREAK/m-p/431526#M106760