Create a column sum of across field in PROC REPORT

DeepSiv — Thu, 20 Feb 2014 16:09:30 GMT

Hi all

I need to do a sum of across field in a PROC REPORT. My proc report looks like this:

PROC REPORT DATA = TEST;

COLUMN A B C,D;

DEFINE A/GROUP;

DEFINE B/GROUP;

DEFINE C/ACROSS;

DEFINE D/ANALYSIS SUM;

RUN;

This creates a report grouping column A, B and across column C. So if C has two possible values - VAL1, VAL2, then it appears like this:

A B VAL1 VAL2

On Two 80 30

I need a column total of VAL1 and VAL2 in a new field. Something like this

A B VAL1 VAL2 TOTAL

On Two 80 30 110

Thanks in advance.

Re: Create a column sum of across field in PROC REPORT

pfep — Tue, 25 Feb 2014 17:28:15 GMT

Hi Deep Siv,

You can try something like this :

data tab1;

input c $ year sales;

cards;

a 2009 10

a 2010 10

a 2011 10

a 2012 10

b 2009 10

b 2010 10

b 2011 10

b 2012 10

;run;

proc report data=tab1 ;

columns c year, sales sales=salessum;

define c /group ;

define year/across order=data;

define sales/analysis sum ;

define salessum/sum 'Total Sales';

run;