topic Sum two variables in Proc Report in SAS Programming

Sum two variables in Proc Report

seboi49 — Mon, 01 Apr 2019 15:44:17 GMT

Hi,

I'm trying to create a sum of two variables with PROC REPORT. I'm new with this procedure and I'm not sure if it is possible to do what I'm looking for. Here is my code :

PROC REPORT data=Res_perfo_overall nowd;
column Ref_Meth_POS nPositivePOS nNegativePOS;
define nPositivePOS / display;
define nNegativePOS / display;
define Ref_Meth_POS / computed "RM POS";
compute Ref_Meth_POS;
	Ref_Meth_POS = nPositivePOS + nNegativePOS;
endcomp;
run;

I'm getting this output :

RM POS nPositivePOS nNegativePOS

.	181	13
.	0	0
.	48	5
.	0	0
.	7	2

I just want to know if it is possible to display the sum of the two colums with proc report instead of creating the variable in a data step (like 181+13, 0+0, 48+5, 0+0 and 7+2). If not I will create it directly in my data but I'm curious if it's possible?

Thank you!

Re: Sum two variables in Proc Report

ballardw — Mon, 01 Apr 2019 16:23:23 GMT

You might try:

PROC REPORT data=Res_perfo_overall nowd;
column  nPositivePOS nNegativePOS Ref_Meth_POS;
define nPositivePOS / display;
define nNegativePOS / display;
define Ref_Meth_POS / computed "RM POS";
compute Ref_Meth_POS;
	Ref_Meth_POS = _c1_ + _c2_;
endcomp;
run;

Proc Report builds tables from left to right. So if you need a calculation then the result must be to the right of all the variables used.

Second to use the values of cells you use the column number to reference, not the variable name.

Re: Sum two variables in Proc Report

seboi49 — Mon, 01 Apr 2019 17:05:14 GMT

All right thank you for your help!