Help! Problem in reading Excel file
Posted: Wed Aug 27, 2014 4:46 am
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
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