POWER Function

Returns the value of a numeric value expression raised to a specified power.

Category: Mathematical
Returned data type: DOUBLE
Syntax
Required Arguments
Details
Example

Syntax

POWER(numeric-expression, power-numeric-expression)

Required Arguments

numeric-expression

specifies any valid SQL expression that evaluates to a numeric value.

Data type BIGINT, DOUBLE, FLOAT, INTEGER, REAL, SMALLINT, TINYINT
See <sql-expression>
FedSQL Expressions

power-numeric-expression

specifies any valid SQL expression that evaluates to a numeric value. This argument is the power value.

Details

If numeric-expression is a null or missing value, then the POWER function returns a null or missing value. If the result is a number that does not fit into the range of a DOUBLE, the POWER function fails.

Example

Table: DENSITIES
The following statements illustrate the POWER function:
Statements
Results
 
select power(5*3, 2);
 
225
 
select name from densities
 where squaremiles >= power(density,2);
 
Afghanistan
Algeria
Angola
Argentina
Australia
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 23, 2017