NMISS Function

Returns the number of null values or SAS missing values in an expression.

Category: Aggregate
Returned data type: BIGINT

Syntax

NMISS(expression)

Arguments

expression

specifies any valid SQL expression.

Data type CHAR, DOUBLE
See <sql-expression>
FedSQL Expressions

Details

NMISS indicates the total number of null or SAS missing values.
You can use an aggregate function to produce a statistical summary of data in the entire table that is listed in the FROM clause or for each group that is specified in a GROUP BY clause. The GROUP BY clause groups data by a specified column or columns. When you use a GROUP BY clause, the aggregate function in the SELECT clause or in a HAVING clause instructs FedSQL in how to summarize the data for each group. FedSQL calculates the aggregate function separately for each group. If GROUP BY is omitted, then all the rows in the table or view are considered to be a single group.

Example

Table: WORLDTEMPS
The following statement illustrates the NMISS function:
Statements
Results
select nmiss(AvgHigh) from worldtemps;
1