I have a dataseries for NOK/EURO exchange rate looking something like this (see attachment):
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
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?