EViews.com

Dear Team,

I want to create a new series(annual) out of specific data-points from other series(monthly).
So I do this in a while loop:

%year = @str(!year)
%yearm = @str(!year) + "M02"
series d_IPC_ann_02(!ind) = @elem(ipcn_forecast_errors::ipc_ann_{%yearm}, {%year}M12)

But when I do this, I get strange numbers which I can't find in any of my files.

Further:
series a1
series a1(1) = @elem(ipcn_forecast_errors::ipc_ann_2009m02, "2009m12")

This command gives also a wrong number, ie. not the number that is in ipc_ann_2009m02 at postion 2009m12. ( I can create the same wrong number in both commands if I specify %year)

and strangely this does not work at all (syntax error):
scalar a1 = @elem(ipcn_forecast_errors::ipc_ann_2009m02, "2009m12")


I tried both "stream" the data from a workfile and from a database, nothing worked. Thing is in another project these things worked well.

Edit: I found out that these strange numbers are averages over the hole year. So the question is how to transfer data from an monthly workfile to an annual workfile.

You'll have to control the frequency conversion by creating a link in your workfile to the data in the database, then use the @elem on that linked series.