Page 1 of 1

DATA

Posted: Fri Aug 26, 2016 12:10 pm
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

Re: DATA

Posted: Fri Aug 26, 2016 12:18 pm
by TomDoan
& is not a legal character in a variable name. Just use something like SP500 (on the file).