EViews.com

Posted: **Fri Dec 26, 2014 2:03 pm**

Hello,
I have a monthly CPI data from 2003 to 2013 in excel I want to create a workfile in Eviews but I fail. First of all, when I open the excel file in eviews and create the data, workfile contains every year seperately. But I need only one file combined each year with each month because when it comes to estimate, I want to estimate 2003-2013 but it shows 2003sep-2003dec. So I don't know what to do. I tried to organize excel file but the same problem happens every time when i open it in eviews. How can i fix this problem?
Thx in advance

Posted: **Fri Dec 26, 2014 2:10 pm**

Can be done interactively or programmatically. Here's the program code:

Code: Select all


wfopen cpi.xlsx
pagestack january february march april may june july august september october november december
alpha date = var01 + " " + @str(series01)
pagestruct @date(@dateval(date))

rename var02 cpi
d id01 series01 var01 date
pagedelete cpi

EViews.com

converting excel file into workfile

converting excel file into workfile

Re: converting excel file into workfile