EViews.com

Posted: **Sat Apr 27, 2013 9:17 pm**

I'm using EV8.

I have data in an Excel table that has Years in rows and Months in columns. Currently, there are 1203 observations.

Is it possible to import this data and convert it into a time series in a single column?

At present, I save it as a text file (just the raw data) and import this to EV. This works but is annoying as I would like to write a programme that imports the data straight from Excel and convert it to the single column, enabling me to process it further.

Posted: **Mon Apr 29, 2013 7:44 am**

Code: Select all


wfopen monthyear.xlsx @rename * m_*
pagestack m_?
alpha yearmonth = @str(year) + "/" + var01
series date = @dateval(yearmonth, "YYYY/MONTH")
pagestruct @date(date)

Posted: **Mon Apr 29, 2013 12:34 pm**

Thanks

EViews.com

Data conversion from Excel

Data conversion from Excel

Re: Data conversion from Excel

Re: Data conversion from Excel