Writing results to Excel

Problems with syntax of GAMS
Job
User
User
Posts: 3
Joined: 3 months ago

Writing results to Excel

Postby Job » 1 month ago

I declared a set as IOZ(sec,secc) and sent the results of an analysis to it. The results display well on the screen but I get error 148 when I tried to create a file with this command
Parameter
result9(*,*) Results reporting
;
result9("IOZ") =IOZ;
Can any one help?

cladelpino
User
User
Posts: 55
Joined: 10 months ago

Re: Writing results to Excel

Postby cladelpino » 1 month ago

Hi:

What do you want to accomplish ? Why not directly write the set IOZ to the file?

A parameter is intended to store a value mapped to each element of a set.

Good luck

Job
User
User
Posts: 3
Joined: 3 months ago

Re: Writing results to Excel

Postby Job » 4 weeks ago

Okay, thanks. But I tried it without success. Eventually this worked:

Parameter
result9b(*,*) Results reporting
;

result9b(sec,secc) =IOZ(sec,secc);
i.e. passing the sets dimensions to each side.


Who is online

Users browsing this forum: No registered users and 3 guests