Code: Select all
pageload(type=odbc, timeout = 900) FilePath\OracleConnection.dsn "SQL code to pull the correct data" @keep *
pageunstack(page = Units, namepat=?_*) COMBOFIELD yearmo @ ?*
The issue I encounter is that the data is automatically pulled into a new page in Eviews called "Units". Even if I already have a "Units" page created, it will not put the data into the old page, but rather create a new one named "Units1" since "Units" is already taken. Is there a way to have the data go into a page that already exists using the pageunstack command?
For now, I am using a for loop to copy over the data into the original page, then delete the new page. However, some of the programs I need to update are pulling a lot of data and the process seems rather tedious. I'd love to find a more straightforward way to pull the data into the correct page in the first place.
Thanks in advance for any suggestions!