Table size

Problems with syntax of GAMS
Post Reply
Manasit
User
User
Posts: 1
Joined: 3 years ago

Table size

Post by Manasit »

Hi all,

I would like to import my SAM table from excel file, using the following code

$CALL gdxxrw.exe SAM_for_GAMS_V3.CSV par=SAM rng=SAM_for_GAMS_V3!A1..CFV2206
$GDXIN SAM_for_GAMS_V3.gdx
$LOAD SAM
$GDXIN

The table has 2 dimensions with 2,205x2,205 observations, however, the GDX file can contain only a portion of them.

I wonder how many observations can GAMS actually allow for one table and, is there any way to increase them?

I also wonder how to display table as a table in GAMS when there are a lot of rows and column, not just the reduced form.

Thank you
abhosekar
Moderator
Moderator
Posts: 295
Joined: 3 years ago

Re: Table size

Post by abhosekar »

Hi,

Size is not the issue here as GDX can deal with much larger datasets.
Please try a smaller example (by removing datapoints) and make sure you can still read all the entries, to make sure that the syntax is correct. Please make sure that you are defining the sets correctly (size 2204). Similarly, make sure you are defining the parameter correctly (over two sets of size 2204). Also, the column and row index in csv file should refer to the sets over which the table is defined.


For your second question, you can use display command
for example,

Code: Select all

display SAM;
will display the table as a table. However, for such a large dataset I don't see how useful it will be.

Hope this helps!
- Atharv
Post Reply