×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Optimization Problem with SAS\OR

Optimization Problem with SAS\OR

Optimization Problem with SAS\OR

(OP)
I'm new to SAS\OR and I'm hoping to use it to solve an optimization problem.  Given my lack of exposure to these procedures to date, I'd appreciate an answer with the appropriate details.


Problem:
I have a dataset of loans (hundreds of thousands) which I need to choose a 'treatment' to maximize each loan's projected net present value of the future cash flows from period t=1 to t=12.  The treatment consists of whether or not, and how much, to reduce the loan's payment.  Future cash flows are a function of the probability of payment (P_hat) in month t, and the principal and interest payment post treatment (PI_Post) in month t.  All cash flows are discounted using the appropriate NPV calculations.


Objective Function:
Max NPV = sum{ 1/(1+d)^t)*(P_hat*PI_Post) } for all t=1 to 12


Where:
d = monthly discount rate

t = each month

P_hat = exp(B0 + B1X1 + B2PR)/(1+exp(B0 + B1X1 + B2PR)) - a logistic regression to be estimated beforehand, which provides the conditional probability of payment in month t

X1 = a set of independent variables

PR = Payment Reduction % (the decision variable)

PI_Post = PI_Pre*(1-PR)

PI_Pre = PI payment before the treatment (ie. payment reduction)

Note that the payment reduction % (PR) affects P_hat as well as PI_Post.



The only constraint is:  -1<PR<=0


If I could paste an actual equation above I could better represent the problem... but I hope that's enough.


My question lies in the optimization technique - which SAS\OR proc would I use for this (perhaps proc nlp)?  Also, please assist with what the syntax would look like.

Thanks.

 
Replies continue below

Recommended for you

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close