Creating an aggregate of single time series components

[michi]

I'm working on some fdi analysis in the following workfile. As I have to concentrate on the NMS10 (BG CZ EE HU LT LV PL RO SK SI) I would like to generate an aggregate for the NMS10 in every workfile page as a "geo country" and "Partner country". Is there a possibility to do that in Eviews or will I have to do it by hand?

[EViews Gareth]

Just so I am sure I understand - you currently have panels as your workfile pages. You want to add a new cross-section ID for those panels where the values are the sum of existing cross-section IDs?

[javiersan]

Hi Gareth, I find this question interesting as well. Assuming that an additional ID is what is needed, how would you go about adding it? I could think about a way through unstacking the panel that seems too involved.
Javier

[EViews Gareth]

Can be tricky. We think the best way to do it is to create an annual page with the sums that you want. Then import that page back into the original page. In this case, for the FGDP_OUT page:

Code: Select all

pagecreate(page=annual) a 1992 2012
series year = @date
copy(smpl=if @inlist(geo, "BG CZ EE HU LT LV PL RO SK SI")=1, c=sum) fgdp_out\fgdp_out annual\fgdp_out @src year @dest year
pagesave c:\temp\tempfile
pageselect fgdp_out
import(resize, mode=ms) c:\temp\tempfile @id @date(year) geo @destid @date(year) geo @genr geo="NMS10"