MAX Function

Returns the largest value.

Category: Descriptive Statistics

Syntax

MAX(argument-1,argument-2<,...argument-n> )

Required Argument

argument

specifies a numeric constant, variable, or expression. At least two arguments are required. The argument list can consist of a variable list, which is preceded by OF.

Comparisons

The MAX function returns a missing value (.) only if all arguments are missing.
The MAX operator (<>) returns a missing value only if both operands are missing. In this case, it returns the value of the operand that is higher in the sort order for missing values.

Example

The following SAS statements produce these results.
SAS Statement
Result 
x=max(8,3);
 
8
 
x1=max(2,6,.);
 
6
 
x2=max(2,-3,1,-1);
 
2
 
x3=max(3,.,-3);
 
3
 
x4=max(of x1-x3);
 
6
Copyright © SAS Institute Inc. All rights reserved.