topic Re: Proc report totals and percentage help in ODS and Base Reporting

Proc report totals and percentage help

Q1983 — Mon, 18 Sep 2017 14:23:06 GMT

data test;

infile datalines;

input ctr $ cnt ;

return;

datalines;

4411 5

4455 15

4466 6

4477 11

;

run;

proc report = test style(summary)=Header;

title 'test';

column ctr cnt PctTot;

define ctr /order order=data style (column)=Header;

define cnt /sum f=comma6.;

define PctTot ?????????????

compute after ctr ;

line ' ';

endcomp;

run;

I am attempting to do the following:

Desired Output

Title ‘ test’

Ctr Cnt PctTot

4411 5 13.51%

4455 15 40.54%

4466 6 16.21%

4477 11 29.72%

Grand Total 37 100.00

I need to round the PctTot 2 decimal places and include lines as well as a Grand Total

Re: Proc report totals and percentage help

ChrisNZ — Mon, 18 Sep 2017 22:51:42 GMT

Does this help?

https://communities.sas.com/t5/SAS-Procedures/Percentages-in-Proc-report/td-p/118539

Re: Proc report totals and percentage help

ChrisNZ — Mon, 18 Sep 2017 22:54:29 GMT

Moved question to ODS and Base Reporting board.

Re: Proc report totals and percentage help

Ksharp — Tue, 19 Sep 2017 13:13:19 GMT

How about this one.


data test;
infile datalines;
input ctr $ cnt ;
return;
datalines;
4411 5
4455 15
4466 6
4477 11
;
run;
 

proc report data= test nowd style(summary)=Header;
title 'test';
column ctr cnt PctTot;
define ctr /order order=data style (column)=Header ;
define cnt /sum f=comma6.;
define PctTot/computed f=percent8.2;
compute before;
 sum=cnt.sum;
endcomp;
compute PctTot;
 pcttot=cnt.sum/sum;
endcomp;
compute after;
 ctr='Total';
endcomp;
rbreak after /summarize;
run;