Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Using Access engines like OLEDB, ODBC or ORACLE result in an

  Error: Invalid Operation
  Error: Termination due to Floating Point Exception

when using the CASE statement with missing values(s) in SAS 9.1.

The same code works in SAS 8.2 and SAS 9.0.

An example of SAS code which gives the above error message is:

   (CASE WHEN x.abc > 0 THEN x.def/x.abc ELSE . END)

The problem only occurs with missing value(s) in the CASE expression.
If you use all non-missing value(s), the query will execute
successfully.

A workaround is to use DIRECT_SQL=NO in the LIBNAME statement. Setting
DIRECT_SQL=NO on the LIBNAME statement indicates that generated SQL is
not passed to the DBMS for processing.

A Technical Support hot fix for SAS 9.1 (TS1M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/b9_sbcs_prod_list.html#012272

Operating System and Release Information

A fix for SAS 9.1 (9.1 TS1M0) for this issue is available at: