Dear all
I am trying to read the attached csv file with the following code:
sets
year /1970*2040/
cartype /gas,dies,gashybr,dieshybr,gashybr_cs,dieshybr_cs,gashybr_phev,dieshybr_phev,electric,fuelcellh2,h2ice,cng,lpg,motor/
sizeall /small, medium, big, all/
size(sizeall) /small, medium, big/
;
Table ProbasAllYears(CARTYPE,SIZE,YEAR)
$ondelim
$include C:\Usr\gams\PLANET\pttv_2018\output\ProbabasAllYearsFuelSize.csv
$offdelim
display ProbasAllYears;
I get the following error messages, but I don’t understand in what sense my file format does not comply with the requirements:
170 Domain violation for element
176 A row with the same name has been defined before in this table.
338 Unique element expected - symbol was not an element
and the following text will be skipped until a proper
symbol is found to recover. Remember that an UNQUOTED
element has to start with a letter or digit
followed by letters, digits, ‘+’, ‘-’ or ‘_’. The length
is limited to 31 characters. The following words are
reserved (starting symbols of a GAMS statement) and cannot
be used for UNQUOTED set elements:
ABORT, ACRONYM(S), ALIAS, BINARY, DISPLAY, ELSE
EQUATION(S), EXECUTE, FILE(S), FOR, FREE, IF, INTEGER, LOOP
MODEL(S), NEGATIVE, OPTION(S), PARAMETER(S)
POSITIVE, PROCEDURE(S), PUT, PUTCLEAR, PUTCLOSE, PUTHD
PUTPAGE, PUTTL, SCALAR(S), SEMICONT, SET(S), SOS1, SOS2
TABLE, VARIABLE(S), WHILE
QUOTED elements can contain any character. Single and
double quotes can be used (starting and ending quote have
to match).
455 Bad or missing delimiter while reading delimited data records
ProbabasAllYearsFuelSize.csv (25.4 KB)