topic Re: How to fix Divide by 0 error in code in SAS Programming

How to fix Divide by 0 error in code

cdw04 — Mon, 01 Feb 2016 18:13:20 GMT

Hi There,

New to SAS coding so if you need more details please let me know

I am getting the following error when to running a code is EG 4.3

ERROR: CLI open cursor error: ERROR: Divide by 0

Sample of data set

ID Card_Sales Card_Used

001 25 5

002 10 8

003 7 2

004 0 0

SAS Code I am using:

Card_Used / Card_Sale as Ratio

Any assistance would be greatly appreicated.

Thanks

Re: How to fix Divide by 0 error in code

Astounding — Mon, 01 Feb 2016 18:18:01 GMT

If you were working in a DATA step, the best way would be to use an IF/THEN statement:

if Card_Sale then Ratio = Card_Used / Card_Sale;

That would skip the processing when Card_Sale is either zero or missing. Since it looks like you are working with SQL instead, you would need to add a CASE statement to assign Ratio a missing value when Card_Sale is zero or missing.

Re: How to fix Divide by 0 error in code

DanZ — Mon, 01 Feb 2016 18:21:50 GMT

data want;
set have;
if card_sales in (0,.) then ratio = 0;
else ratio = card_used/card_sales;
run;

Re: How to fix Divide by 0 error in code

Ksharp — Tue, 02 Feb 2016 01:44:29 GMT

Use function DIVIDE().

ratio =divide( card_used,card_sales) ;

Re: How to fix Divide by 0 error in code

Rick_SAS — Tue, 02 Feb 2016 13:36:40 GMT

You should set ratio=. (missing value) if the denominator is invalid. Using zero is not correct.