topic Re: Any examples from Solver/EXCEL to OPTMODEL in Mathematical Optimization, Discrete-Event Simulation, and OR https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/787599#M3577 <P>Linear optimization? Quadratic programming? Nonlinear optimization?</P> <P>Please post the problem that you would like to solve and any data.&nbsp;</P> <P>&nbsp;</P> <P>The documentation for PROC OPTMODEL is the best place to start:</P> <UL> <LI><A href="https://documentation.sas.com/doc/en/ormpug/15.2/ormpug_optmodel_gettingstarted.htm" target="_self">Getting started examples</A></LI> <LI><A href="https://documentation.sas.com/doc/en/ormpug/15.2/ormpug_optmodel_examples.htm" target="_self">Other optimization examples</A></LI> </UL> <P>&nbsp;</P> Sat, 08 Jan 2022 03:32:33 GMT Rick_SAS 2022-01-08T03:32:33Z Any examples from Solver/EXCEL to SAS/OPTMODEL https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/787574#M3575 <P>I know Solver/EXCEL but new to SAS/OPTMODEL.</P><P>&nbsp;</P><P>Anyone has concrete examples from Solver/EXCEL to SAS/OPTMODEL. Links,</P><P>&nbsp;</P><P>Thanks,</P> Wed, 29 Dec 2021 02:05:37 GMT https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/787574#M3575 hellohere 2021-12-29T02:05:37Z Any examples from Solver/EXCEL to OPTMODEL https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/787573#M3576 <P>I know Solver/EXCEL but new to SAS/OPTMODEL.&nbsp;</P><P>&nbsp;</P><P>Anyone has concrete examples from Solver/EXCEL to SAS/OPTMODEL.</P><P>Links,&nbsp;</P><P>&nbsp;</P><P>Thanks,&nbsp;</P> Wed, 29 Dec 2021 02:00:09 GMT https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/787573#M3576 hellohere 2021-12-29T02:00:09Z Re: Any examples from Solver/EXCEL to OPTMODEL https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/787599#M3577 <P>Linear optimization? Quadratic programming? Nonlinear optimization?</P> <P>Please post the problem that you would like to solve and any data.&nbsp;</P> <P>&nbsp;</P> <P>The documentation for PROC OPTMODEL is the best place to start:</P> <UL> <LI><A href="https://documentation.sas.com/doc/en/ormpug/15.2/ormpug_optmodel_gettingstarted.htm" target="_self">Getting started examples</A></LI> <LI><A href="https://documentation.sas.com/doc/en/ormpug/15.2/ormpug_optmodel_examples.htm" target="_self">Other optimization examples</A></LI> </UL> <P>&nbsp;</P> Sat, 08 Jan 2022 03:32:33 GMT https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/787599#M3577 Rick_SAS 2022-01-08T03:32:33Z Re: Any examples from Solver/EXCEL to OPTMODEL https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/787702#M3578 <P>Rickļ¼š</P><P>&nbsp;</P><P>Thanks for reply.&nbsp; I have a problem below. 4 Entities, 2 exclusive States, 2 measurements,&nbsp;</P><P>need find the max sum of cross-product. Know how to use Solver/EXCEL, new to&nbsp;</P><P>OPTMODEL. You can help on how to specify var/con/max/solve...?!</P><P>&nbsp;</P><P>The SAS example, I read over but still somehow hard to code correctly.&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>State</TD><TD>Entity1</TD><TD>Entity2</TD><TD>Entity3</TD><TD>Entity4</TD></TR><TR><TD>S1</TD><TD>9.9</TD><TD>6.1</TD><TD>1.4</TD><TD>7.1</TD></TR><TR><TD>S2</TD><TD>5.9</TD><TD>5.9</TD><TD>3.0</TD><TD>0.1</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>State</TD><TD>Entity1</TD><TD>Entity2</TD><TD>Entity3</TD><TD>Entity4</TD></TR><TR><TD>S1</TD><TD>5.7</TD><TD>9.8</TD><TD>1.1</TD><TD>5.3</TD></TR><TR><TD>S2</TD><TD>1.3</TD><TD>7.8</TD><TD>8.5</TD><TD>9.5</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CrossProduct</TD><TD>56.3</TD><TD>60.4</TD><TD>1.5</TD><TD>37.6</TD></TR><TR><TD>&nbsp;</TD><TD>7.6</TD><TD>46.0</TD><TD>25.6</TD><TD>0.9</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>SUM(CP)</TD><TD>236.0</TD></TR></TBODY></TABLE> Thu, 30 Dec 2021 00:44:32 GMT https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/787702#M3578 hellohere 2021-12-30T00:44:32Z Re: Any examples from Solver/EXCEL to SAS/OPTMODEL https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/788152#M3582 <P>You can find numerous such examples in this community:</P> <P><A href="https://communities.sas.com/t5/forums/searchpage/tab/message?filter=location&amp;q=excel&amp;advanced=false&amp;location=forum-board:operations_research" target="_blank">https://communities.sas.com/t5/forums/searchpage/tab/message?filter=location&amp;q=excel&amp;advanced=false&amp;location=forum-board:operations_research</A></P> Mon, 03 Jan 2022 17:31:59 GMT https://communities.sas.com/t5/Mathematical-Optimization/Any-examples-from-Solver-EXCEL-to-SAS-OPTMODEL/m-p/788152#M3582 RobPratt 2022-01-03T17:31:59Z