Search found 63 matches

by Jarenka
2 years ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 11
Views: 4391

Re: CSV Input Using SQL2GMS

I am already working with including *.txt file (or *.dat file) into GAMS. My code is the following: set Ik /Ik01, Ik02, Ik03/ R /R01 * R08/ Vt /Vt01,Vt02/; $if %system.filesys% == UNIX $abort.no error 'The model cannot run on a non-Windows platform'; $onecho > fixedtextcmd.txt C=DRIVER={Microsoft Te...
by Jarenka
2 years ago
Forum: Syntax
Topic: Using GAMS on Mac OS X Environment with Wine bottler
Replies: 14
Views: 6430

Re: Using GAMS on Mac OS X Environment with Wine bottler

bussieck wrote:
2 years ago
www.gams.com/download

-Michael
I just wanted to say that I found it. Thank you Michael !!
by Jarenka
2 years ago
Forum: Syntax
Topic: Using GAMS on Mac OS X Environment with Wine bottler
Replies: 14
Views: 6430

Re: Using GAMS on Mac OS X Environment with Wine bottler

Hi, GAMS Studio is about to be released (in a month or two) in it's first version (see https://forum.gamsworld.org/viewtopic.php?f=8&t=10198#p23354 ). In the meantime you might want to check the contributed software page with some alternative UI for GAMS: https://www.gams.com/community/contributed-...
by Jarenka
2 years ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 4005

Re: SAS files into GAMS

Dear Renger,
Thank you.
Yes, but the problem is that I do not want to use any indirect program between SAS and GAMS.
In this case you suggest I have to use R to direct a data file to GAMS from SAS.

Is there any way to do it without any indirect program?

Best
irena
by Jarenka
2 years ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 4005

SAS files into GAMS

Dear, I would like to know whether there is a possibility to read files from SAS into GAMS. Instead of, for example, Excel or csv files, I would like to use SAS data inputs. The reason of that is that on the machine, which we use to create our projects, we store a huge amount of data in SAS data bas...
by Jarenka
2 years ago
Forum: Syntax
Topic: How to update parameters iteratively within a Loop?
Replies: 5
Views: 2182

Re: How to update parameters iteratively within a Loop?

Dear GabrielYin,

Yes, I did it as you said and it works.!

I am very used to R-program and SAS, so for me it is something new.

Thank you for your help!!
by Jarenka
2 years ago
Forum: Syntax
Topic: How to update parameters iteratively within a Loop?
Replies: 5
Views: 2182

Re: How to update parameters iteratively within a Loop?

Dear, I have a similar problem, but instead of updating parameter I would like to write it in in a matrix/array at each iteration. My code is the following: *parameters xNpjf(P,Jn); set ITR /ITR0 * ITR5/; parameter mat_xNpjf(P,Jn,ITR); loop(ITR, solve $include "C:\Users\is\Documents\gamsdir\projdir\...
by Jarenka
2 years ago
Forum: Syntax
Topic: relational operators within GAMS
Replies: 6
Views: 2721

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
2 years ago
Forum: Syntax
Topic: relational operators within GAMS
Replies: 6
Views: 2721

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
2 years ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 11
Views: 4391

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?