HASNA - Check input for observations with missing Value

Check whether the input array contains any missing values and returns TRUE or FALSE.

Syntax

HASNA(X, Option)

X

is the data set you chose to test. X can refer to a cell range, a formula, or a name that refers to cell ranges, values, or formulas.

Option

is a logical value: to check only for intermediate missing value(s) = TRUE or omitted; to check for any missing value = FALSE.

Remarks

1. The time series is homogeneous or equally spaced.
2. The searches for a missing value (i.e., #N/A or empty cell) in the input time series.

Files Examples

Related Links

• What to do About Missing Values in Time Series Cross-Section Data, James Honaker and Gary King, American Journal of Political Science.

References

• Paul D. Allison; Missing Data; SAGE Publications, Inc; 1st Edition(Aug 13, 2001), ISBN: 0761916725.
• Hamilton, J .D.; Time Series Analysis, Princeton University Press (1994), ISBN 0-691-04289-6.
• Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0-471-690740.