Hi
I have the following code in my input window:
OPEN DATA "C:\Users\p.sivtanides\research\cyclical_behavior\CYHPI-3.XLS"
CALENDAR(Q) 2004:1
DATA(FORMAT=XLS,ORG=COLUMNS) 2004:01 2013:04 HPI RGDPGR RGDPSA HHS PCHHS HPERMITS CPI TOTEMP CCOST RATE POP NOMGDP CBHPI
When I run these lines I get the message:
## IO30. There is no series HPI on the file
## IO30. There is no series RGDPGR on the file
## IO30. There is no series ..........
The Excel file is fine and it does contained data organized in columns. Can anybody provide clues why I get this error?
Your help will be greatly appreciated.
Thanks,
Petros
Help! Problem in reading Excel file
Re: Help! Problem in reading Excel file
That looks like it was generated by the Data Wizard. Is that correct? Did the series labels come off the file, or did you have to input them?