Create a column sum of across field in PROC REPORT

Reply
Contributor
Posts: 50

Create a column sum of across field in PROC REPORT

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.

Frequent Learner
Posts: 1

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

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;

Ask a Question
Discussion stats
  • 1 reply
  • 248 views
  • 0 likes
  • 2 in conversation