Hi everyone, first of all, let me introduce myself. My name is Marcos Oba and I already programmed in SAS some years ago. I built a MILP optimizer that was a standalone solution (all data was feed from txt files and all results was exported to txt files). Now I have a new challenge: I need to build a MILP optimizer that reads data from a Oracle DB, manipulate these data myself (in the first project, all data was received ready to process), build scenarios and run these scenarios recursively. In another words, using some algorithms, run small optimizations in loops to get near global optimal solution (the reasons to run it recursively and not a global optimization are due to the first modeling tool – Lindo´s Whats Best, and the main directive now is to implement it as is in SAS). So, there are 2 main tasks that I´m not familiar: Read, manipulate, and write Oracle DB´s Program a recursive process I never worked with Enterprise Guide (always a code direct in SAS with a text editor), but this does not look an issue. But I´m not familiar with the required connections to make it work. Anybody can show me the path, or at least what documentation I need to follow? Some examples are really welcome! Sorry for the poor English. Regards, Marcos
... View more