fetching data into existing workfile

[tjriddle]

Here is the situation. I have monthly data variable in a workfile from 1965 to 2032, say CPI. I want to fetch updated data for 2009 to 2033 from an eviews data base but I do not want to overwrite the existing data from 1965 to 2008. In other words, I want to replace part of the time series, not all of it and be assured that the part of the data I am not interested in changing stays the same. I do not want to have to change the name of the time series either.

[EViews Gareth]

If the database only has data in it from 2009 to 2033, then you can merge in that data, and the original data from 1965-2008 will be left intact.

Otherwise I think the best option is rename the variable, fetch in the database version, merge the two series together, then rename it back.

Something like:

Code: Select all

rename cpi temp
fetch cpi
smpl 2009 2032
temp=cpi
smpl @all
d cpi
rename temp cpi


[tjriddle]

I would suggest, as an improvement to the software, that you allow overwrites of just a prtion of the data. Much simpler.

[tjriddle]

It appears that in version five you had an option under "OBJECT" called "Update from DB" this option disappeared in version 6.

Will it do what I need?

[EViews Gareth]

Update from DB is still there in 6, but it does exactly the same thing as Fetch.