DIVS by 0 Error

[dhunited12]

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 🙂

[RW9 · Accepted solution]

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

[dhunited12]

Thank you so much !