Search found 6 matches

by Jarenka
6 days ago
Forum: Syntax
Topic: relational operators within GAMS
Replies: 6
Views: 747

Re: relational operators within GAMS

Thank you, it works !!
OMG, you are so helpful!!
And thank you for the link!

Kind regards
Jarenka
by Jarenka
1 week ago
Forum: Syntax
Topic: relational operators within GAMS
Replies: 6
Views: 747

Re: relational operators within GAMS

Dear, I have a problem with loop statement. set P /P01 * P08/ Jn /Jn01 * Jn10/ Jm /Jm01 * Jm10/ parameters p1(P,Jm) p2(P,Jn); I would like to have the following: p1(P,jm) = p2(P,jn) - the values jn from p2 to be taken to jm in p1, for each P. I tried this: for(P, for (jm (p1(P,jm) = p2(P,jn)); ); );...
by Jarenka
1 week ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 9
Views: 536

Re: CSV Input Using SQL2GMS

Finally, I did it! Thank you!

I would like to see the data in *.lst file. And I am using "display" option for that.

Why instead of values I receive "YES" ? How can I change it?
by Jarenka
2 weeks ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 9
Views: 536

Re: CSV Input Using SQL2GMS

Dear Renger, gdxxrw has helped in reading in all the spread sheets into gdx file. The problem now starts when I want to load, for example, first parameter: "LOAD bNP". It says: "Load dimensions are different". And I have been trying to figure out what I have been doing wrong. I have changed a little...
by Jarenka
2 weeks ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 9
Views: 536

Re: CSV Input Using SQL2GMS

Hi Renger, Thank you for your answer! Yes, you right. I have given up SQL procedure and moved to this: $libinclude xlimport inter_consumpP C:\Users\is\Documents\gamsdir\projdir\Data\DATA_til_GAMS.xlsx bNpjifD!a2:d1362 It succeeded in reading in sheets, but I have found another problem. When GAMS rea...
by Jarenka
2 weeks ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 9
Views: 536

Re: CSV Input Using SQL2GMS

Dear, I have a problem in reading in all variables from spreadsheet, using SQL2GMS. As you can see below. It can only read 'qaeg' and 'yloraeg' from below code, but not the rest: 'var1','var2','var3' and 'var4'. * specifying axes (sets) and indexes (elements): Set P "Production_Place" /P01 * P08/; S...