NA versus zero values
Posted: Sat Jun 23, 2018 12:47 am
I have some time series that in some periods have "NA"
I set the "NA" to zero with the following expression:
smpl @all if SERIES1 =NA
genr SERIES1 = 0
However, when I sum SERIES1 with another complete SERIES2, the generated SERIES3 has exactly the "NA" of SERIES1:
SERIES3 = SERIES1 + SERIES2 (SERIES3 contains "NA")
Amazingly, if I open as a group SERIES3 and SERIES1, SERIES3 does no longer contain the "NA"
What's going on?
I set the "NA" to zero with the following expression:
smpl @all if SERIES1 =NA
genr SERIES1 = 0
However, when I sum SERIES1 with another complete SERIES2, the generated SERIES3 has exactly the "NA" of SERIES1:
SERIES3 = SERIES1 + SERIES2 (SERIES3 contains "NA")
Amazingly, if I open as a group SERIES3 and SERIES1, SERIES3 does no longer contain the "NA"
What's going on?