topic Re: DIVS by 0 Error in SAS Enterprise Guide

DIVS by 0 Error

dhunited12 — Wed, 20 Jun 2018 13:00:20 GMT

Hello all,

I am trying to run a query

(SUM(AMNT_OF_CHEESE)) / (SUM(AMNT_OF_BREAD)) AS CHEESEBREAD

but am getting

"ERROR: Error fetching from cursor. ORACLE error is ORA-01476: divisor is equal

to zero" in the log. Yes, some days there are no bread.

I'm new to SAS EG and tried resolving the issue by cases but have been failing for the past hour. Any help would be greatly appreciated!

Thank you in advance 🙂

Re: DIVS by 0 Error

RW9 — Wed, 20 Jun 2018 13:09:10 GMT

Well, first off that is an Oracle error, not a SAS one. But I would do:

case when sum(amnt_of_cheese) >0 and sum(amnt_of_bread) > 0 then  sum(amnt_of_cheese) / sum(amnt_of_bread) 
     else 0 end as cheesebread

Re: DIVS by 0 Error

dhunited12 — Wed, 20 Jun 2018 14:12:33 GMT

Thank you so much !