DATA

For questions and discussion related to reading in and working with data.
Zankawa
Posts: 65
Joined: Mon Jun 15, 2015 2:23 pm

DATA

Unread post by Zankawa »

Hi,
I am loading data into RATS and I am getting an error message as follows;

OPEN DATA "H:\Ghana Data\Datagh.xlsx"
CALENDAR(M) 1991:1
DATA(FORMAT=XLSX,ORG=COLUMNS,SHEET="Sheet2") 1991:01 2015:12 Period COP EXR GSMKT GSECI S&P500 LCOP LEXR $
LGSECI LS&P500 DLCOP DLEXR DLGSECI DLS&P500 DUMMY
## SX11. Identifier S is Not Recognizable. Incorrect Option Field or Parameter Order?
>>>> EXR GSMKT GSECI S&<<<<

I am not sure why I am getting this error message. The series appear in the program but all their values are empty. I desperately need some assistance as to how to resolve this problem.
Thank you
TomDoan
Posts: 7814
Joined: Wed Nov 01, 2006 4:36 pm

Re: DATA

Unread post by TomDoan »

& is not a legal character in a variable name. Just use something like SP500 (on the file).
Post Reply