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 SAS 9.1 and SAS/ACCESS to compare a numeric field to '.' in a
WHERE clause or CASE expression will result in the following error:

  ERROR: Invalid Operation.
  ERROR: Termination due to Floating Point Exception

or

  ERROR: Domain error.
  ERROR: Termination due to Floating Point Exception

When using the WHERE clause a workaround is to alter the code from:

           where var='.'
to

           where var is NULL

When using the CASE statement the only workaround is to turn off
implicit passthrough by adding the option, DIRECT_SQL=NO, to the LIBNAME
statement.

If referencing a PROC SQL view created against the RDBMS data and this
error is issued, another possible work-around would be to create a SAS
data set with PROC SQL against the RDBMS data instead of a PROC SQL
view.

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#012222


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

http://www.sas.com/techsup/download/hotfix/c9_sbcs_prod_list.html#012222

For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/c9_dbcs_prod_list.html#012222

Operating System and Release Information

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

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

A fix for SAS 9.1.2 (9.1 TS1M2) with Asian Language Support (DBCS) for this issue is available at: