There are several SAS Global Forum papers on dosubl:   https://www.lexjansen.com/search/search_sgf.php?q=dosubl   Start with papers by Rick Langston and Mike Rhoads, in addition to the paper by Jason Secosky that has already been mentioned.   https://support.sas.com/resources/papers/proceedings13/032-2013.pdf   https://support.sas.com/resources/papers/proceedings12/004-2012.pdf       ... View more

What is your exact problem ? Please share. ... View more

If y - x is in [-M_1,M_1] and y - (20 - x) is in [-M_2,M_2] for suitably chosen constants M_1 and M_2, you can linearize the relationship between x and y by introducing a binary variable z and the following constraints: -M_1 * z <= y - x <= M_1 * z -M_2 * (1 - z) <= y - (20 - x) <= M_2 * (1 - z)   If z = 0, the first pair of constraints force y = x.  If z = 1, the second pair of constraints force y = 20 - x.   Depending on your objective and other constraints, you might be able to avoid the bounds and binary variables.  For example, if you want to maximize y, you can just impose y <= x and y <= 20 - x. ... View more

Its my understanding that the SAS AMO interface is designed to surface SAS content into the Microsoft tool it is being called from, so rows and columns into Excel, text-style reports into Word, XML-based reports into Powerpoint, not to display other content "on the side". In other words you are trying to do something with AMO that it was never designed to do. If you are simply wanting a SAS tool that will interface with pre-generated reports, then I suggest you look at SAS Web Report Studio.  ... View more

Yes data changes are required in real time. So loading data at the start of optmodel won't going to work. ... View more