merge series from two different panel workfiles

For questions of any nature based on EViews 5 or earlier versions of EViews.

Moderators: EViews Gareth, EViews Moderator

Posts: 5
Joined: Mon Nov 12, 2012 7:33 pm

merge series from two different panel workfiles

Postby jasonrobards » Mon Nov 12, 2012 7:58 pm

Using version 5.1. Have two workfiles with similar, but not identical, dated unbalanced panel layouts. Annual data from 1989 to 2010 with 112 countries in one file, 114 countries in the other. Each country has < or = 22 annual observations (countries don't have observations in every year - note that these aren't zeros, they're "NA"s) for each variable, but the years in which "NA"s appear aren't the same across variables. Ex: value of tp_mz=100 in 1989 for Australia in workfile 1 and no observation for lp_mz in 1989 for Australia in workfile 2. I want to merge(?) or paste special(?) the series from workfile 1 to workfile 2 so that I can add these two series together to create a new series (ex: total_mz=tp_mz+lp_mz). Can't figure out how to do this in a way that the copied series corresponds to the correct dates. Is this a merge issue or a copy special issue?

Return to “EViews 5 and Earlier”

Who is online

Users browsing this forum: No registered users and 1 guest