topic Re: Division by zero in New SAS User

Division by zero

sasuser1031 — Thu, 12 Dec 2019 20:28:38 GMT

how can I fix if there are zeros in b? I want to change b=1 when b=0 and run this code when b>0.

Code:
if (a < 1000 OR

(a/b <.1 & c < 5000000 & d IN (0,.)) OR

(a/b < .1 & c < 10000000 & d IN (0,.)) OR

(a < 500000 & c < 5000000 & d IN (0,.)) OR

(a < 1000000 & c < 10000000 & d IN (0,.))) then e = 1;

Log:

NOTE: Division by zero detected at line 1393 column 29.
NOTE: Division by zero detected at line 1394 column 29.

Re: Division by zero

PaigeMiller — Thu, 12 Dec 2019 20:33:11 GMT

@sasuser1031 wrote:

how can I fix if there are zeros in b? I want to change b=1 when b=0 and run this code when b>0.

Code:
if (a < 1000 OR

(a/b <.1 & c < 5000000 & d IN (0,.)) OR

(a/b < .1 & c < 10000000 & d IN (0,.)) OR

(a < 500000 & c < 5000000 & d IN (0,.)) OR

(a < 1000000 & c < 10000000 & d IN (0,.))) then e = 1;

Log:

NOTE: Division by zero detected at line 1393 column 29.
NOTE: Division by zero detected at line 1394 column 29.

Before this IF statement, use

b=b*(b>0) + (b=0);

So if b>0, we use the value of b. If b=0 we use the value 1.

Re: Division by zero

ed_sas_member — Thu, 12 Dec 2019 20:37:04 GMT

Hi @sasuser1031

Once you've changed b=0 to b=1, do you want to run the code for this new value of b, or do you want to run this code only when b is initially different from 0?

If it is the first cas, you can try the below code.

Best,

data want;
	set have;
	if b=0 then b=1;
	if b>0 then do;
		if (a < 1000) OR
	  	 (a/b <.1 & c < 5000000 & d IN (0,.)) OR
	  	 (a/b < .1 & c < 10000000 & d IN (0,.)) OR
	  	 (a < 500000 & c < 5000000 & d IN (0,.)) OR
	  	 (a < 1000000 & c < 10000000 & d IN (0,.)) then e = 1;
	   end;
run;

Re: Division by zero

Ksharp — Fri, 13 Dec 2019 10:17:14 GMT

Using function DIVIDE() instead.

if (a < 1000 OR

( divide(a,b) <.1 & c < 5000000 & d IN (0,.)) OR

( divide(a,b) < .1 & c < 10000000 & d IN (0,.)) OR

(a < 500000 & c < 5000000 & d IN (0,.)) OR

(a < 1000000 & c < 10000000 & d IN (0,.))) then e = 1;

Re: Division by zero

sasuser1031 — Fri, 13 Dec 2019 14:42:10 GMT

I want to run the code for both.

Re: Division by zero

Tom — Fri, 13 Dec 2019 15:29:47 GMT

So you want to change the zeros in B to ones?

if b=0 then b=1;

If you do first that then your code will run without any divide by zeros.

if (a<1000)
  or (((a/b)<0.1) and (c< 5000000) and d in (., 0))
  or (((a/b)<0.1) and (c<10000000) and d in (., 0))
  or ((a< 500000) and (c< 5000000) and d in (., 0))
  or ((a<1000000) and (c<10000000) and d in (., 0))
  then e=1
;

If you only want to do it only when B is > 0 then add that to the code. Note that if you test after you have change the zeros to ones then B will now be > 0.