topic Re: Proc report compute in SAS Programming

Proc report compute

USHAKS — Wed, 04 Mar 2020 23:22:07 GMT

compute ChangeN;
_c4_ = (_c3_ - _c2_);
endcomp;

when _C3_ is 2

and column _C2_ 0

I want to see -2

but I am seeing in _c4_ 0

how to solve it.

Re: Proc report compute

PaigeMiller — Wed, 04 Mar 2020 23:42:49 GMT

@USHAKS wrote:

compute ChangeN;
_c4_ = (_c3_ - _c2_);
endcomp;

when _C3_ is 2

and column _C2_ 0

I want to see -2

but I am seeing in _c4_ 0

how to solve it.

How about

_c4_ = _c2_-_c3_;

Re: Proc report compute

USHAKS — Thu, 05 Mar 2020 03:33:12 GMT

compute ChangeN;
_c4_ = (_c3_ - _c2_);
endcomp;

C3 is 2020 sales
c2 is 2019 sales

when it is c3 is 13
and c2 is 15 I get -2

Assume C3 is 2020 sales and it is 0
C2 2019 sales 2
I do not get -2

thanks,