merge series from two different panel workfiles
Posted: 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?