Search for workfile series in database and fetch with suffix
Posted: Fri Oct 28, 2016 8:58 am
I have a page within a workfile containing a bunch of series.
I also have a database with the exact same series (and series names), but the time series data might be a bit outdated.
I'd like to search for each series in my workfile page in my EViews database and fetch those exact series with a "_01" appended as a suffix to the series name. This is for comparison purposes before I update those series in my database. Not sure how to go about this but here is what I'm trying to do.
I also have a database with the exact same series (and series names), but the time series data might be a bit outdated.
I'd like to search for each series in my workfile page in my EViews database and fetch those exact series with a "_01" appended as a suffix to the series name. This is for comparison purposes before I update those series in my database. Not sure how to go about this but here is what I'm trying to do.
Code: Select all
pageselect Newdata
dbopen(type=eviews) "p:\filepath\database.edb"
for !j=1 to count("Newdata") 'How do I find out the total number of series in workfile page?
fetch(m, s="01") 'How would I fetch each series?
next