Help! Problem in reading Excel file

For questions and discussion related to reading in and working with data.
Petros
Posts: 12
Joined: Mon Aug 25, 2014 2:20 am

Help! Problem in reading Excel file

Unread post by Petros »

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
TomDoan
Posts: 7814
Joined: Wed Nov 01, 2006 4:36 pm

Re: Help! Problem in reading Excel file

Unread post by TomDoan »

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?
Post Reply