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.
@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.
Show the code or better the code with the error messages from the log.
@sewa_bal_gmail_com wrote:
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.
@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."
@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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.