creating a new output (.csv) file to put data into?

GAMS
1

Hi everyone! I’m extremely new to gams programming (I have programmed in a variety of other languages though) and I’m looking for a little advice.
I have a (in my opinion) gigantic model that I’m working with… 10+ input .gms files and also a large number of .gms files that seem to be written during the running of the… solver I guess it it?

During the run it outputs a bunch of .csv files with data in them. I need data from the model/solver that it is not currently putting into any file, and I need it to be in a .csv or something so that I can get the data into excel to be manipualted there.
I think I will be able to figure out how to make it put the data into the actual file and loop through the source .gms file that it is currently sitting in…

My question is: how to I ‘initalize’ the new file to write the data into? Do I even need to? does "put"ting the data into the file… decalaring what file puts will refer to create the file if it is not already in existance? Or is it a separate command to actually make and name the file?

Also, I have code in the pre-existing gams files such as:
Put test%1;

  • stuff in the put, looping through and "put"ting more data

Putclose test%1

and as far as I can tell, the initial “Put test%1” is what dictates which file it will write subsequent ‘puts’ to. Does this also create the file “test”? If not, how would I go about creating that file? also, what does the ‘%1’ at the end of ‘test’ do/refer to? it is not actually in any of the .csv output file names yet all the inital put statements referencing the file names have the ‘%1’ at the end.


Thank you all for reading and I hope someone can help :slight_smile:

-Confused SnyperBunny.

–
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

\

2

Hi SnyperBunny



I don’t know why you want to write a csv-file as Gams has a great utility to write data more or less directly to Excel.

Take a look at the gdx-utility (the manual can be found in your gams directory). There are many posts on how to use this utility.

Gdxxrw can send or import data to and from Excel.

Cheers

Renger

Modelworks

Gewerbestrasse 15

3600 Thun – Switzerland

+41 79 818 53 73

Info@modelworks.ch

blog.modelworks.ch







From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of SnyperBunny
Sent: Dienstag, 16. April 2013 21:05
To: gamsworld@googlegroups.com
Subject: creating a new output (.csv) file to put data into?



Hi everyone! I’m extremely new to gams programming (I have programmed in a variety of other languages though) and I’m looking for a little advice.

I have a (in my opinion) gigantic model that I’m working with… 10+ input .gms files and also a large number of .gms files that seem to be written during the running of the… solver I guess it it?



During the run it outputs a bunch of .csv files with data in them. I need data from the model/solver that it is not currently putting into any file, and I need it to be in a .csv or something so that I can get the data into excel to be manipualted there.

I think I will be able to figure out how to make it put the data into the actual file and loop through the source .gms file that it is currently sitting in…



My question is: how to I ‘initalize’ the new file to write the data into? Do I even need to? does "put"ting the data into the file… decalaring what file puts will refer to create the file if it is not already in existance? Or is it a separate command to actually make and name the file?



Also, I have code in the pre-existing gams files such as:

Put test%1;

  • stuff in the put, looping through and "put"ting more data

Putclose test%1



and as far as I can tell, the initial “Put test%1” is what dictates which file it will write subsequent ‘puts’ to. Does this also create the file “test”? If not, how would I go about creating that file? also, what does the ‘%1’ at the end of ‘test’ do/refer to? it is not actually in any of the .csv output file names yet all the inital put statements referencing the file names have the ‘%1’ at the end.





Thank you all for reading and I hope someone can help :slight_smile:



-Confused SnyperBunny.

–
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


\

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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

\

3

It can?? Really? Thats cool, I’ll take a look at that.
Why I was wanting to write to a .csv is mostly for the sake of consitancy with the rest of the model - it writes data to multiple different csv files already, then we have a large macro in Excel that opens various .csv files and pulls the data from these before formatting it into graphs and whatnot.


On Wednesday, 17 April 2013 00:33:52 UTC-7, Renger van Nieuwkoop wrote:

Hi SnyperBunny



I don’t know why you want to write a csv-file as Gams has a great utility to write data more or less directly to Excel.

Take a look at the gdx-utility (the manual can be found in your gams directory). There are many posts on how to use this utility.

Gdxxrw can send or import data to and from Excel.

Cheers

Renger

Modelworks

Gewerbestrasse 15

3600 Thun – Switzerland

+41 79 818 53 73

In…@modelworks.ch

blog.modelworks.ch







From: gams...@googlegroups.com [mailto:gams...@googlegroups.com] On Behalf Of SnyperBunny
Sent: Dienstag, 16. April 2013 21:05
To: gams...@googlegroups.com
Subject: creating a new output (.csv) file to put data into?



Hi everyone! I’m extremely new to gams programming (I have programmed in a variety of other languages though) and I’m looking for a little advice.

I have a (in my opinion) gigantic model that I’m working with… 10+ input .gms files and also a large number of .gms files that seem to be written during the running of the… solver I guess it it?



During the run it outputs a bunch of .csv files with data in them. I need data from the model/solver that it is not currently putting into any file, and I need it to be in a .csv or something so that I can get the data into excel to be manipualted there.

I think I will be able to figure out how to make it put the data into the actual file and loop through the source .gms file that it is currently sitting in…



My question is: how to I ‘initalize’ the new file to write the data into? Do I even need to? does "put"ting the data into the file… decalaring what file puts will refer to create the file if it is not already in existance? Or is it a separate command to actually make and name the file?



Also, I have code in the pre-existing gams files such as:

Put test%1;

  • stuff in the put, looping through and "put"ting more data

Putclose test%1



and as far as I can tell, the initial “Put test%1” is what dictates which file it will write subsequent ‘puts’ to. Does this also create the file “test”? If not, how would I go about creating that file? also, what does the ‘%1’ at the end of ‘test’ do/refer to? it is not actually in any of the .csv output file names yet all the inital put statements referencing the file names have the ‘%1’ at the end.





Thank you all for reading and I hope someone can help :slight_smile:



-Confused SnyperBunny.

–
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


\

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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

\