Page 1 of 1
fetching data into existing workfile
Posted: Tue Jun 09, 2009 9:10 am
by 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.
Re: fetching data into existing workfile
Posted: Tue Jun 09, 2009 9:25 am
by 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
Re: fetching data into existing workfile
Posted: Tue Jun 09, 2009 9:51 am
by tjriddle
I would suggest, as an improvement to the software, that you allow overwrites of just a prtion of the data. Much simpler.
Re: fetching data into existing workfile
Posted: Tue Jun 09, 2009 12:37 pm
by 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?
Re: fetching data into existing workfile
Posted: Tue Jun 09, 2009 12:38 pm
by EViews Gareth
Update from DB is still there in 6, but it does exactly the same thing as Fetch.