## Adding a percentage to a PRoc Report

Solved
Frequent Contributor
Posts: 112

# Adding a percentage to a PRoc Report

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

Accepted Solutions
Solution
‎11-23-2017 11:20 PM
Posts: 1,270

## Re: Adding a percentage to a PRoc Report

Hi,

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;

All Replies
Solution
‎11-23-2017 11:20 PM
Posts: 1,270

## Re: Adding a percentage to a PRoc Report

Hi,

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;

Frequent Contributor
Posts: 112

## Re: Adding a percentage to a PRoc Report

Thanks @stat_sas

Is exactly what I was looking for.

Cheers

Dean

☑ This topic is solved.