EViews.com

Hello again,
I have a panel of country level data over a certain time period.
I am running the regression for 2 subsets of countries, e.g. ASIA and EUROPE.
I keep the (frozen) equations in 2 pages: ASIA_page and EUROPE_page. On these pages I have my forecast variable Y_hat for ASIA and EUROPE forecast.
I would like to combine these two forecasts into one variable, in a new page WORLD (so that I can then export this result to excel)
In other words, how can I combine two series in 2 different pages into one?
Thanks,
Lenka

Create the world page as a panel, with two cross-sections (ASIA and EUROPE). Copy the series over from each page to the world page, using date and continent as id variables.

thank you, I'll give it a try

Hi, the problem is that the resulting series get overwritten in the process.

y_hat for ASIA contains NA's for EUROPE and vice versa.
So when I copy:
copy EUROPE\f_diesel SUMMARY\
copy ASIA\f_diesel SUMMARY\f_diesel @src @date region @dest @date region
EUROPE portion of f_diesel gets overwritten by NA's

I tried to put a merge option into copy command:
copy (merge) ASIA\f_diesel SUMMARY\f_diesel @src @date region @dest @date region
but I am getting an error "invalid ID list"

I was trying to modify the ID list, include cross-section identifier, but doesn't work

Could you provide the workfile.

I am attaching an excerpt of a workfile, plus the program I am trying to run.

You have spaces between the merge command and its options.

ouch, that was easy
may thanks!

You're not the first, you won't be the last