BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

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

View solution in original post

5 REPLIES 5
ballardw
Super User

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

 

 

 

sewa_bal_gmail_com
Quartz | Level 8

 

@ballardw 

 

Thanks

Here is a log. It worked very well in 9.3

 

sewa_bal_gmail_com_1-1589227075654.png

 

 

ballardw
Super User

@sewa_bal_gmail_com wrote:

 

@ballardw 

 

Thanks

Here is a log. It worked very well in 9.3

 

sewa_bal_gmail_com_1-1589227075654.png

 

 


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
Quartz | Level 8

@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
Super User Tom
Super User

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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

What is ANOVA?

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.

Discussion stats
  • 5 replies
  • 3950 views
  • 0 likes
  • 3 in conversation