MEAN Function

Returns the arithmetic mean (average) of the non-null or nonmissing arguments.

Category: Descriptive Statistics
Returned data type: DOUBLE
Syntax
Arguments
Comparisons
Example
See Also

Syntax

MEAN(expression-1[, ...expression-n])

Arguments

expression

specifies any valid expression that evaluates to a numeric value.

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

Comparisons

The GEOMEAN function returns the geometric mean, the HARMEAN function returns the harmonic mean, whereas the MEAN function returns the arithmetic mean (average).

Example

The following statements illustrate the MEAN function:
Statements
Results 
select mean(2,.,.,6);
 
4
 
select mean(1,2,3,2);
 
2

See Also

Functions:
GEOMEAN Function
GEOMEANZ Function
HARMEAN Function
HARMEANZ Function
MEDIAN Function
Copyright © SAS Institute Inc. All rights reserved.