Search found 50 matches

by Jarenka
10 months ago
Forum: Archive Google Group
Topic: Looping over file names
Replies: 29
Views: 13867

Re: Looping over file names

Hi, I was trying to understand the looping over the files names, but your conversation simply doesn't say anything to me. My problem is the following: I would like to loop over the years, which are part of the names in the parameters. Here in the attachment is an example for 2008. I would like to lo...
by Jarenka
10 months ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 2532

Re: SAS files into GAMS

Guys, I think I did it. I am sorry for posting so many posts, but I feel so excited by it. Anyway, on the foto1 there is my last R-code that reads id *.dat file (shown in my previous post). In GAMS program you have specify the code in foto2. Be careful about the following things in R: - when you spe...
by Jarenka
10 months ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 2532

Re: SAS files into GAMS

For those who are working with R and GAMS, this could be helpful. I think I corrected above problem. In attachment there is a new R-code, which works in GAMS. In foto1 there is output in GAMS - a table "alldata" with dimensions and variables. In foto2 there is corrected R-code for this. Now, I am tr...
by Jarenka
10 months ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 2532

Re: SAS files into GAMS

And foto4 attached below:
by Jarenka
10 months ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 2532

Re: SAS files into GAMS

So far is good. Firstly, I had to install gdxrrw package by using *.zip file, which fortunately was under GAMS folder :-) - and that was very good, because we work on the research machines (Windows 32-bit) that do not have access to the Internet due to confidentiality. In the attachment, at the bott...
by Jarenka
10 months ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 2532

Re: SAS files into GAMS

Yes, it works! Thank you! I am attaching the "screen-cut" from my program. On the left hand side there is my code with specified variables. On the right hand side there is a screen-display from R-program (the first data-file with dimensions and variables). You can see which parameters I want to incl...
by Jarenka
10 months ago
Forum: Tools
Topic: SAS files into GAMS
Replies: 11
Views: 2532

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
10 months ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 11
Views: 2983

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

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

bussieck wrote:
10 months ago
www.gams.com/download

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

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