How to replicate excel solver using proc optmodel ?

Reply
N/A
Posts: 1

How to replicate excel solver using proc optmodel ?

Hi,

I have a model built in excel where the r and alpha parameters of a gamma distribution was optimized using the solver function.

I have to replicate the same thing in sas.

The Following is the equation that has been used :

lnΓ(r + x)− lnΓ(r)+ r ln(α) − (r + x) ln(α + T) which when coded  looks like

GAMMALN($B$1+B6)-GAMMALN($B$1)+$B$1*LN($B$2)-($B$1+B6)*LN($B$2+C6

(B1= r & B2 = alpha)

I calculated the log likelihood first with r and alpha as 1. Then i maximized the log-likelihood by placing constraints like r and alpha are > 0 and is a small +ve integer number >= 0.00001

Can someone tell me how to replicate this in SAS using proc optmodel or is there any other way to do this.

Thanks for the help!

SAS Employee
Posts: 433

Re: How to replicate excel solver using proc optmodel ?

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.

Ask a Question
Discussion stats
  • 1 reply
  • 411 views
  • 0 likes
  • 2 in conversation