Having data on yearly basis but want to have it on monthly basis

Hello,

so my issue is that I have for one variable data available on a yearly basis - meaning for each year t I have one value. For another variable the data is available on a monthly basis.

How can I get the yearly data on a monthly level meaning that I have a vector which contains for the 1st 12 elements the value of the first year, for the elements 13-24 the value for the second year and so one...

Thanks in adavance.

Nico

Answer 1

[Simon Chan]

Read about function retime

Answer 2

[Star Strider]

This is not the correct approach. Interpolating yearly data to monthly data creates data where none previously existed. Once the monthly data are lost they cannot be recovered, unless the original monthly data were saved separately. The comparison will not be correct. If they were, use the original monthly data.

If the original monthly data are not available, do the reverse instead, and use retime to aggregate the monthly data to yearly data. The result of that comparison will then at least be reliable.