Finding sets from data/table

GAMS
1

Good morning,

I’ve a problem, similar to the following example!!!

First I must define sets without specifying elements, because the table can vary (sources and places here). Then I must assign to sources the elements seattle and Sandiego and to places the elements newyork and chicago.

Example:

alias(sources,places,*)

table c(sources,places)

newyork chicago

seattle 2.5 1.7

Sandiego 2.5 1.8 ;


I will be really glad if someone can answer. Otherwise, thanks anyway.

Please help me.

Thank you

–
To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/1cdwCySMDf8J.
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.

2

Il giorno venerdì 5 ottobre 2012 10:51:29 UTC+2, WhiteWolf ha scritto:

Good morning,

I’ve a problem, similar to the following example!!!

First I must define sets without specifying elements, because the table can vary (sources and places here). Then I must assign to sources the elements seattle and Sandiego and to places the elements newyork and chicago.

Example:

alias(sources,places,*)

table c(sources,places)

newyork chicago

seattle 2.5 1.7

Sandiego 2.5 1.8 ;



and in the case where the table were imported from excel sheet?



I will be really glad if someone can answer. Otherwise, thanks anyway.

Please help me.

Thank you

–
To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/qbq7mPiTKiUJ.
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.