Desktop productivity for business analysts and programmers

DIVS by 0 Error

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

DIVS by 0 Error

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 Smiley Happy


Accepted Solutions
Solution
‎06-20-2018 10:12 AM
Super User
Super User
Posts: 9,794

Re: DIVS by 0 Error

Posted in reply to dhunited12

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

View solution in original post


All Replies
Solution
‎06-20-2018 10:12 AM
Super User
Super User
Posts: 9,794

Re: DIVS by 0 Error

Posted in reply to dhunited12

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
New Contributor
Posts: 3

Re: DIVS by 0 Error

Posted in reply to dhunited12
Thank you so much !
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 92 views
  • 0 likes
  • 2 in conversation