Programming Data Merging
Posted: Fri Apr 20, 2012 6:52 am
I've got an existing database and for one of the programs I've written, I'm truing to import new data for some of the variables from an excel file. However, I can't figure out how to program that so the final series I end up with is merger of the database series and the excel file series. I'm not sure how clear this explanation is so I've got an example below.
I'm trying to end up with a merged series for CTDDNT. The approach I've been trying is
(Here the series CTDDNT runs from 1978 2000)
(Here the series CTDDNT runs from 2001 to 2009)
However when I program it like this, I just get the 2001-2009 series. How can I merge the two?
I'm trying to end up with a merged series for CTDDNT. The approach I've been trying is
Code: Select all
'Upload data from database source
FETCH(D={%SOURCEDATA}Database\OUTLOOK.EDB) CTDDNT Code: Select all
import P:\Test.xls
However when I program it like this, I just get the 2001-2009 series. How can I merge the two?