Other statements are not affected by the setting of NASKIP, they always ignore NA values.

Arithmetic Operators in Function Arguments

NASKIP does not affect arithmetic operators; the NASKIP2 option controls how NA values are treated with the + (plus) and - (minus) operators. When NASKIP2 is set to YES, zeroes are substituted for NA values in arithmetic operations with the + (plus) and - (minus) operators. This means that when a + (plus) and - (minus) operator are used in an expression argument to an aggregation function, the result of the calculation depends on the settings of both NASKIP and NASKIP2.

$NATRIGGER Takes Precedence over NAFILL or NA Options

An $NATRIGGER property expression is evaluated before the NAFILL function or the NASKIP, NASKIP2, or NASPELLoption is applied. When the $NATRIGGER expression is NA, the NAFILL function and the NA options have an effect.

In the demo workspace, the 1997 values for sales are NA. The TOTAL function returns different results depending on the setting of NASKIP.

The statements

ALLSTAT
NASKIP = YES
SHOW TOTAL(sales)

produce the following result.

63,181,743.50

In contrast, the OLAP DML statements

NASKIP = NO
SHOW TOTAL(sales)

produce the following result.

NA

Example 18-15 The Effect of NASKIP on the MOVINGMIN Function

This example aggregates values for three months: the current month and the two months before it. The first report of SALES shows the NA values for months in 1997. When NASKIP is YES, the MOVINGMIN function returns NA only for March 1997 because all the values considered for that month were NA. When NASKIP is NO, the third statement (REPORTDOWNmonthsales) shows NA values for January through March 1997, because at least one value considered by MOVINGMIN for those months was NA.

LIMIT district TO 'Seattle'
LIMIT month TO 'Jul96' TO 'Mar97'
REPORT DOWN month sales