Page 1 of 1
Excel import - dates in columns
Posted: Mon Aug 17, 2009 7:53 am
by javiersan
Hi,
I have an Excel file which has dates in the first column and the variables in rows, is there a way of specifying in EViews that the first line of the file is the date information?
See for example the file attached.
Thanks for your help.
Javier
Re: Excel import - dates in columns
Posted: Mon Aug 17, 2009 8:04 am
by EViews Gareth
Not with WFOPEN, but there is the "t" option with the READ command. However, in your case I think the READ command probably still won't work since your columns are "backwards" (i..e you have the latest date on the left, and the earliest date on the right).
It might be best to just transpose the data in Excel.
Re: Excel import - dates in columns
Posted: Mon Aug 17, 2009 9:52 am
by EViews Gareth
With some EViews magic, you can get the data in via WFOPEN:
Code: Select all
wfopen test.xls
pagestack _?
d id02
pageunstack series01 id01
pagestruct @date(id01)
d _ series01 id01
rename _* *
pagedelete test
pagedelete test_stk
Pretty messy though...
Re: Excel import - dates in columns
Posted: Tue Aug 18, 2009 12:13 pm
by javiersan
Thanks for taking the time to write the program. I have managed to work with the "read" command with "t" option and some previous work in Excel.
Regards,
Javier