BookmarkSubscribeRSS Feed
buttadam
Calcite | Level 5

Hello all,

I've been using SAS for a decent amount of time with a financial model for superannuation investment.  Basically what I've done already is built a model that optimizes (minimizes) the equity allocation using the average of a simulated objective function (1,000 simulations).  The optimization is currently done by calculating the objective function for all possible allocations from 0% - 100% and picking the lowest value.  Now I'm looking to do something a little more complicated and would like to use PROC OPTMODEL to do the optimization.

The only problem with this is that it seems that I can't simply bring in a macro to PROC OPTMODEL that calculates the objective function.  However it seems like it would be very difficult (if not impossible) to calculate the objective function within PROC OPTMODEL given it currently involves at least 100 lines of code and an average of 1,000 output variables.

Does anyone have any ideas on what my best approach would be?  I'm leaning towards writing my own optimization program within my current code, but would love any feedback on how I could use a SAS procedure to do this - especially since there is a second variable (in addition to equity allocation) that I want to optimize against.  The optimization itself should be fairly easy - as the constraints are linear and the objective function appears to be convex.

Thanks,

Adam.

1 REPLY 1
RobPratt
SAS Super FREQ

Questions about PROC OPTMODEL in SAS/OR are better suited for the Mathematical Optimization and Operations Research Community.  If you still need help, please post there.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1183 views
  • 0 likes
  • 2 in conversation