Referencing subsets in GDXXRW

GAMS
1

Hi,

I am trying to define some parameter data using the GDXRW function.

My code looks like the following:

set y years /2010,2015,2020/ ;

set i countries

/Austria,Belarus,Belgium, Bos_herz, Bulgaria,Croatia,Czech_rep,Denmark,Estonia,
Finland,France,Germany,Greece,Hungary,Ireland,Italy,Latvia,Lithuania,Luxembourg,
Macedonia,Moldova,Netherlands,Norway,Poland,Portugal,Romania,Serbia,Slovakia,
Slovenia,Spain,Sweden,Switzerland,UK,
Ukraine,Georgia,Morocco,Tunisia,Turkey,
Algeria,Azerbaijan,Egypt,Iran,Libya,Nigeria,Oman,Qatar,Russia,Trin_tob,Yemen,US
/;



sets

BNL(i) Benelux /Belgium, Netherlands,Luxembourg/
DEU(i) Germany /Germany/
EEN(i) Eastern Europe North /Estonia,Lithuania,Latvia,Czech_rep,Slovakia,Poland/
EES(i) Eastern Europe South /Bos_herz,Slovenia,Hungary,Romania,Bulgaria,Greece,Croatia,Serbia,Macedonia,Moldova/
FRA(i) France /France/
IAM(i) Italy Austria *Malta /Italy, Austria/
IBE(i) Iberia /Spain, Portugal/
NOI(i) Norway *Iceland /Norway/
SDF(i) Sweden Denmark Finland /Sweden, Denmark, Finland/
SWZ(i) Switzerland /Switzerland/
UKI(i) UK and Ireland /Ireland, UK/
EXO(i) Exogenous supply regions /Algeria,Azerbaijan,Egypt,Iran,Libya,Nigeria,Oman,Qatar,Russia,Trin_tob,Yemen/
TRANSIT(i) Transit countries /Belarus,Ukraine,Georgia,Morocco,Tunisia,Turkey/ ;


$CALL GDXXRW.exe GASNET_inputs.xls par=test rng=test!A2:E50 Cdim=1 Rdim=1
parameter test(i,y) ;
$gdxin GASNET_inputs.gdx
$load test
$GDXIN
display test

And the excel file being read by GDXXRW looks like:

2010 2015 2020
Austria 1 1.5 2
Germany 2 3 4
exo 3 4.5 6
transit 4 6 8

I would like GDXXRW to read in some subsets of the data (exo and transit) rather than name all i individually. However, when I run the model,the GDXXRW function doesn’t recognise these subsets.

Can anyone point me in the correct direction here? I’ve looked through the documentation; there doesn’t seem to be anything pointing to how to do this.

Best,

Stevie


\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

2

Hi Stevie



You perhaps could do the following


\

  •      Define the parameter test as test(*,y);

  •      Read the parameter using gdxxrw.

  •      Use:

o parameter test2(*,y);

o test2(exo,y) = test(“exo”,y);



Be aware of “exo” (not exo).

Hope this helps.



Cheers

Renger





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Stevie Lochran
Sent: Mittwoch, 25. November 2015 01:35
To: gamsworld
Subject: Referencing subsets in GDXXRW



Hi,



I am trying to define some parameter data using the GDXRW function.



My code looks like the following:



set y years /2010,2015,2020/ ;



set i countries



/Austria,Belarus,Belgium, Bos_herz, Bulgaria,Croatia,Czech_rep,Denmark,Estonia,

Finland,France,Germany,Greece,Hungary,Ireland,Italy,Latvia,Lithuania,Luxembourg,

Macedonia,Moldova,Netherlands,Norway,Poland,Portugal,Romania,Serbia,Slovakia,

Slovenia,Spain,Sweden,Switzerland,UK,

Ukraine,Georgia,Morocco,Tunisia,Turkey,

Algeria,Azerbaijan,Egypt,Iran,Libya,Nigeria,Oman,Qatar,Russia,Trin_tob,Yemen,US

/;







sets



BNL(i) Benelux /Belgium, Netherlands,Luxembourg/

DEU(i) Germany /Germany/

EEN(i) Eastern Europe North /Estonia,Lithuania,Latvia,Czech_rep,Slovakia,Poland/

EES(i) Eastern Europe South /Bos_herz,Slovenia,Hungary,Romania,Bulgaria,Greece,Croatia,Serbia,Macedonia,Moldova/

FRA(i) France /France/

IAM(i) Italy Austria *Malta /Italy, Austria/

IBE(i) Iberia /Spain, Portugal/

NOI(i) Norway *Iceland /Norway/

SDF(i) Sweden Denmark Finland /Sweden, Denmark, Finland/

SWZ(i) Switzerland /Switzerland/

UKI(i) UK and Ireland /Ireland, UK/

EXO(i) Exogenous supply regions /Algeria,Azerbaijan,Egypt,Iran,Libya,Nigeria,Oman,Qatar,Russia,Trin_tob,Yemen/

TRANSIT(i) Transit countries /Belarus,Ukraine,Georgia,Morocco,Tunisia,Turkey/ ;





$CALL GDXXRW.exe GASNET_inputs.xls par=test rng=test!A2:E50 Cdim=1 Rdim=1

parameter test(i,y) ;

$gdxin GASNET_inputs.gdx

$load test

$GDXIN

display test



And the excel file being read by GDXXRW looks like:




2010


2015


2020

Austria


1


1.5


2

Germany


2


3


4

exo


3


4.5


6

transit


4


6


8



I would like GDXXRW to read in some subsets of the data (exo and transit) rather than name all i individually. However, when I run the model,the GDXXRW function doesn’t recognise these subsets.



Can anyone point me in the correct direction here? I’ve looked through the documentation; there doesn’t seem to be anything pointing to how to do this.



Best,



Stevie






\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.