topic Re: Adding a percentage to a PRoc Report in SAS Enterprise Guide

Adding a percentage to a PRoc Report

DME790 — Fri, 24 Nov 2017 03:36:13 GMT

Hi All,

I'm trying to add a percentage from the 'total' in a proc report. I have read a couple of submissions but not making sense to me.

My data looks like 9apologies if the test data doesn't work)

data test;
input ORIGIN_CD TARGET_CD SP04 SP05 SP06 Total;
datalines;

ABR A 14 12 6 32
ABR B 2 . 1 3
ABR C . 2 1 3
ABR D . 1 . 1
ABR E . . 1 1
ABR F . 1 . 1
ABR G 1 . 1 2
ABR H . 1 . 1
ABR I . . 4 4
ABR J 1 1 1 3
ABR K 1 1 . 2
ABR L . . 1 1
ABR M 1 3 9 13
;
Run;

My code is

Proc Report data=work.origindestbyqueuecalc;
	by origin_cd;
	Column ORIGIN_CD TARGET_CD SP04 SP05 SP06 Total ;
	define Origin_CD / Display 'Origin';
	Define Target_CD / DISPLAY 'Destination';
	Define SP04 / DISPLAY 'SP2018_04' analysis SUM f=comma9.;
	Define SP05 / DISPLAY 'SP2018_05' analysis SUM f=comma9.;
	Define SP06 / DISPLAY 'SP2018_06' analysis SUM f=comma9.;
	Define Total / DISPLAY 'Total' analysis sum;
	Rbreak after / summarize;
RUN;

which gives me the output of

and I would like the output to look like the following

Any help appreciated

Cheers

Dean

Re: Adding a percentage to a PRoc Report

stat_sas — Fri, 24 Nov 2017 04:12:45 GMT

Hi,

Please try this.

Proc Report data=work.test;
by origin_cd;
Columns ORIGIN_CD TARGET_CD SP04 SP05 SP06 Total Total,(pctsum);
define Origin_CD / Display 'Origin';
Define Target_CD / DISPLAY 'Destination';
Define SP04 / DISPLAY 'SP2018_04' analysis SUM f=comma9.;
Define SP05 / DISPLAY 'SP2018_05' analysis SUM f=comma9.;
Define SP06 / DISPLAY 'SP2018_06' analysis SUM f=comma9.;
Define Total / DISPLAY 'Total' analysis sum;
Define pctsum / 'Percentage' format=percent6. width=8;
Rbreak after / summarize;
RUN;

Re: Adding a percentage to a PRoc Report

DME790 — Fri, 24 Nov 2017 04:21:29 GMT

Thanks @stat_sas

Is exactly what I was looking for.

Cheers

Dean