topic Re: Division by zero error in SAS Programming

Division by zero error

Prateek1 — Tue, 11 Oct 2016 07:05:59 GMT

hi,

i am getting this kind of error:

R: Limit set by ERRORS= option reached. Further errors of this type will not be printed.

Division by zero detected at line 88 column 27

Mathematical operations could not be performed at the following places. The results of the
operations have been set to missing values.
Each place is given by: (Number of times) at (Line):(Column).
2044 at 80:28
NOTE:

my code is :

data Y.Ce;
set Y.Cc;
Average_Purchase=(Purchases/Purchases_trx);
run;

Re: sas

Kurt_Bremser — Tue, 11 Oct 2016 07:33:42 GMT

@Prateek1 wrote:

hi,

i am getting this kind of error:

R: Limit set by ERRORS= option reached. Further errors of this type will not be printed.

Division by zero detected at line 88 column 27

Mathematical operations could not be performed at the following places. The results of the
operations have been set to missing values.
Each place is given by: (Number of times) at (Line):(Column).
2044 at 80:28
NOTE:

my code is :

data Y.Ce;
set Y.Cc;
Average_Purchase=(Purchases/Purchases_trx);
run;

The NOTE about the Limits is irrelevant. What's really important is/are the error message(s) BEFORE that.

Please post the whole log of the data step (redundant repeated messages can be omitted).

Cancel that. "Division by zero" message not detected because of insufficient caffeine level. EBKAC.

Re: sas

Reeza — Tue, 11 Oct 2016 07:03:49 GMT

The Error is:

Division by zero detected at line 88 column 27

Is this happening in your calculation? If so, fix it so it doesn't.

Re: Division by zero error

Kurt_Bremser — Tue, 11 Oct 2016 07:22:13 GMT

The culprit is this:

Average_Purchase=(Purchases/Purchases_trx);

If Purchases_trx happens to be zero, this is an invalid calculation. A division by zero yields (per mathematical definition) infinity, which cannot be handled by SAS (and most other programming environments).

So you need to either

- remove observations where Purchases_trx is zero

- or test if Purchases_trx is zero and than set a "default" value

In your case I'd do

if Purchases_trx = 0
then Average_Purchase = 0;
else Average_Purchase = Purchases / Purchases_trx;

Re: Division by zero error

RW9 — Tue, 11 Oct 2016 08:48:12 GMT

Ideal use for ifn()

average_purchase=ifn(purchases_trx=0,0,purchases/purchases_trx);

Re: Division by zero error

Ksharp — Tue, 11 Oct 2016 11:34:06 GMT

average=divide(purchases,purchases_trx);

Re: Division by zero error

SpaceMonkey — Thu, 25 May 2017 05:45:45 GMT

IFN does not seem to prevent divide by zero errors when I use it. For example:

data test;
  x = 0;
  y = ifn(x = 0, 0, 1/x);
run;

This still generates an error in the log:

NOTE: Division by zero detected at line 35 column 22.
x=0 y=0 _ERROR_=1 _N_=1

Why? If X=0 then IFN should return 0 (second argument). The 1/X condition should never be evaluated.

Can someone please explain? Thanks very much.

Re: Division by zero error

Kurt_Bremser — Thu, 25 May 2017 08:17:59 GMT

It is a peculiarity of the ifn and ifc functions that they seem to always evaluate all expressions; this comes in handy when you need to conditionally use the result of a lag() function.

Re: Division by zero error

RW9 — Thu, 25 May 2017 08:39:57 GMT

Its because its a function. Normally the if statement is processed and stops when it needs to, i.e:

if x=1 then do abc=3;

^ ^

The compiler evaluates this part, and only moves onto the then if that is true. The compiled function however is treated as a block ie:

abc=ifn(x=1,3,0)

^ ^

The compiler treats the whole lot as condition/result due to being a function.

@SpaceMonkey: Please dont re-open 8 month old topics for a new discussion, start a new topic.

Re: Division by zero error

Reeza — Mon, 29 May 2017 01:10:47 GMT

@SpaceMonkey wrote:

If a thread is open, I'll comment on it. If you don't like that, tough for you.

@SpaceMonkey Threads are never closed on here.