SAS ERROR: Floating Point Zero Divide.

[sewa_bal_gmail_com]

Hi,

I am getting below error after migrating to SAS 9.4 from 9.3 while running proc stdrate

ERROR: Floating Point Zero Divide.

ERROR: Termination due to Floating Point Exception

I can see there are no zero values in the respected column.

[ballardw]

Show the code or better the code with the error messages from the log.

[sewa_bal_gmail_com]

@ballardw 

Thanks

Here is a log. It worked very well in 9.3

[ballardw]

---

@sewa_bal_gmail_com wrote:

@ballardw 

Thanks

Here is a log. It worked very well in 9.3

---

Was this run against the exact same data set? If not then very likely there is something different in the data.

That does not show the code run with options so very limited. So the places to look are extremely limited from the amount of information we have to work with.

I would look to see if any of your By variable groups have other variable(s) with all value identical. But that is a guess.

[sewa_bal_gmail_com]

@ballardw  Thanks

What do you mean by "I would look to see if any of your By variable groups have other variable(s) with all value identical."

[Tom · Accepted solution]

---

@sewa_bal_gmail_com wrote:

@ballardw  Thanks

What do you mean by "I would look to see if any of your By variable groups have other variable(s) with all value identical."

---

The redacted part of the image should tell you which BY group to look at.

It might be that you have some group where the standard deviation is almost zero and it is confusing SAS.

If you can't figure it out you can open a ticket with SAS support to do more detailed analysis.