![spss 25 spss 25](https://statistics.laerd.com/spss-tutorials/img/cdv/create-dummy-variables-menu-in-spss-statistics.png)
Both base and log value should be positive. LOG − It returns the algorithm value of a passed positive value. LN − It returns the natural logarithm of the argument. HEXTOBIN − It converts a hexadecimal value to a binary value. It takes numeric values or strings with numeric characters and return numeric values.ĪBS − It returns the absolute value of a numeric argument.Įxample − SELECT ABS (-1) "abs" FROM TEST ĪCOS, ASIN, ATAN, ATAN2 (These functions return trigonometric value of the argument)īINTOHEX − It converts a Binary value to a hexadecimal value.īITAND − It performs an AND operation on bits of passed argument.īITCOUNT − It performs the count of number of set bits in an argument.īITNOT − It performs a bitwise NOT operation on the bits of argument.īITOR − It perform an OR operation on bits of passed argument.īITSET − It is used to set bits to 1 in from the position.īITUNSET − It is used to set bits to 0 in from the position.īITXOR − It performs XOR operation on bits of passed argument.ĬEIL − It returns the first integer that is greater or equal to the passed value.ĬOS, COSH, COT ((These functions return trigonometric value of the argument)ĮXP − It returns the result of the base of natural logarithms e raised to the power of passed value.įLOOR − It returns the largest integer not greater than the numeric argument. These are inbuilt numeric functions in SQL and use in scripting.
![spss 25 spss 25](https://image.slidesharecdn.com/help-130722143342-phpapp01/95/spss-help-2-638.jpg)
There are various SQL functions provided by SAP HANA database −