Frequency conversion:
I have a dataseries for NOK/EURO exchange rate looking something like this (see attachment):
7/02/2000 8.058999999999999
8/02/2000 8.071999999999999
9/02/2000 8.0825
10/02/2000 8.0695
11/02/2000 8.0395
12/02/2000
13/02/2000
14/02/2000 8.0795
15/02/2000 8.0685
16/02/2000 8.112500000000001
17/02/2000 8.1565
18/02/2000 8.1455
19/02/2000
20/02/2000
that is, a daily frequency with alot of NA values. When converting to anual frequency, i want to take the average of the non-NA values, i.e., i use the command:
Code: Select all
euro.setconvert a
However, I do not want the annual series to show a value for 2017. Correspondingly, I do not want the quarterly series showing a value for 2017:q3.
In general, when using frequency conversion, how can I make it so that a series will show NA in the period (quarter, month, year) belonging to the current date?
Thomas