If you use one or more SAS^® LASR™ Analytic Server tables as input to a query, an error might be displayed if the query includes a WHERE or HAVING clause. Specifically, if the clause uses a function that is not supported by the SAS LASR Analytic Server, then you see an error that is similar to this one on the Messages tab.

For example, the following functions are not supported on a WHERE or HAVING clause. If you install the hot fix from the Hot Fix tab in this note, these functions no longer appear as selections on the Functions tab when you create the expression for the WHERE or HAVING clause. However, the tab still includes other functions, such as YEAR and SUBSTR, that are not supported on a WHERE or HAVING clause. Some functions are still available because they are supported in the SELECT statement.

• abs
• ceil
• exp
• floor
• log
• ln
• mod
• round
• trunc

Note: Even if you cannot select the function from the Functions tab, SAS Visual Data Builder does not prevent you from manually entering an expression that uses an unsupported function. To avoid the error, do not use any of the unsupported functions.

Operating System and Release Information

A fix for this issue for SAS Visual Analytics 6.2_M1 is available at: