STD Function

Returns the standard deviation.

Categories: Aggregate
Descriptive Statistics
Returned data type: DOUBLE
Syntax
Arguments
Example

Syntax

STD(expression-1, expression-2 [, ...expression-n])

Arguments

expression

specifies any valid expression that evaluates to a numeric value.

Requirement At least two non-null or nonmissing arguments are required. Otherwise, the function returns a null or missing value.
Data type DOUBLE
See <sql-expression>
FedSQL Expressions.

Example

The following statements illustrate the STD function:
Statements
Results 
select std(2,6);
 
2.82842712474619
 
select std(2,6,.);
 
2.82842714274619
 
select std(2,4,6,3,1);
 
1.92353840616714
Copyright © SAS Institute Inc. All rights reserved.