Search found 64 matches

by Jarenka
5 years ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 10732

Re: SAS files into GAMS

I am also trying to include R program, which you wrote, into GAMS.

Do I need to specify something more? Like for example:
- path to my R-script,
- global options at the beginning of the GAMS program to "tell" GAMS that I am going to read in data from R.

Best
Irena
by Jarenka
5 years ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 11
Views: 10230

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
5 years ago
Forum: Syntax
Topic: Using GAMS on Mac OS X Environment with Wine bottler
Replies: 14
Views: 14674

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

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

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

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/contribu...
by Jarenka
5 years ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 10732

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
5 years ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 10732

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
5 years ago
Forum: Syntax
Topic: How to update parameters iteratively within a Loop?
Replies: 5
Views: 6384

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
5 years ago
Forum: Syntax
Topic: How to update parameters iteratively within a Loop?
Replies: 5
Views: 6384

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\pro...
by Jarenka
5 years ago
Forum: Syntax
Topic: relational operators within GAMS
Replies: 6
Views: 6567

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

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)); ); );...