topic Re: SAS ERROR: Floating Point Zero Divide. in Statistical Procedures

SAS ERROR: Floating Point Zero Divide.

sewa_bal_gmail_com — Mon, 11 May 2020 18:08:04 GMT

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.

Re: SAS ERROR: Floating Point Zero Divide.

ballardw — Mon, 11 May 2020 18:51:52 GMT

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

Re: SAS ERROR: Floating Point Zero Divide.

sewa_bal_gmail_com — Mon, 11 May 2020 19:58:13 GMT

@ballardw

Thanks

Here is a log. It worked very well in 9.3

Re: SAS ERROR: Floating Point Zero Divide.

ballardw — Mon, 11 May 2020 20:03:12 GMT

@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.

Re: SAS ERROR: Floating Point Zero Divide.

sewa_bal_gmail_com — Mon, 11 May 2020 20:24:58 GMT

@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."

Re: SAS ERROR: Floating Point Zero Divide.

Tom — Mon, 11 May 2020 20:32:58 GMT

@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.