topic Add a new field to proc report with total of some fields in a row in SAS Programming

Add a new field to proc report with total of some fields in a row

Ronein — Wed, 11 Jul 2018 11:08:29 GMT

Hello

I have simple proc report example.

I have 4 numeric fields and I want to create one more column with sum of x1,x2,x3,x4.

Please pay attention that it might happen that in x1,x2,x3,x4 there is a null value.

 Data tbl;
 input branch X1  X2  X3  X4;
 cards;
 1  10 20 30 40 
 2  15 20 25 30
 3  35 40 45 50
 4  55 60 65 .
 ;
 run;


proc report data=tbl  headline split='#' spacing=1 nowd
style(report)={cellpadding=1 cellspacing=1}
style(header)={font_size=2  font_weight=MEDIUM  font_face=david  background=cx99ccaa}
style(column)={font_size=1}; 
columns  branch X1  X2  X3  X4 ;
define branch/ display 
	"Branch"  center;
define X1/  Display "X1 amount";
define X2/  Display "X2 amount";
define X3/  Display "X3 amount";
define X4/  Display "X4 amount";
Run;

Re: Add a new field to proc report with total of some fields in a row

Ronein — Wed, 11 Jul 2018 11:46:07 GMT

I found the answer

proc report data=tbl headline split='#' spacing=1 nowd
style(report)={cellpadding=1 cellspacing=1}
style(header)={font_size=2 font_weight=MEDIUM font_face=david background=cx99ccaa}
style(column)={font_size=1};
columns branch X1 X2 X3 X4 total;
define branch/ display
"Branch" center;
define X1/ Display "X1 amount";
define X2/ Display "X2 amount";
define X3/ Display "X3 amount";
define X4/ Display "X4 amount";
define total/computed;
compute total;
total=sum(x1,x2,x3,x4);./*Will not get null if there is null value in x1,x2,x3,x4*/
endcomp;
Run;
/*total=x1+x2+x3+x4; */
/*Will get null if there is null value in x1,x2,x3,x4*/