- example 8.4 and 19.4 in http://www.amsterdamoptimization.com/pdf/sql2gms.pdf
- a practical example: http://www.amsterdamoptimization.com/models/blog/rawcsvdata3-2.gms
- technical info on the ODBC Text Driver: http://support.microsoft.com/kb/178717, http://msdn.microsoft.com/en-us/library/ms714091%28VS.85%29.aspx
Hello
ReplyDeleteThank you for this site it's very useful. I want to ask you how to import a csv multidimensional table example data(loc,time,loc,time) (time and loc are alias) if it is a sparse matrix.
I have a sparse matrix (420row and 420 column (84 location for 5 years rows and column) and don’t fit a excel file so I introduced as a CSV (comma separate) file. However I don't know how to write sets in the CSV file, I put the 2 column sets separated by a comma but I don’t know how to write the row sets and where to put the "dummy".
Thank you very much
Ben Arfa Nejla
n.benarfa@group-esa.com
The best place to get free GAMS support is support@gams.com.
ReplyDelete