Checks 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

- The time series is homogeneous or equally spaced.
- 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

## Comments

Article is closed for comments.