BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi. I have not built models in SAS before, but any help would be greatly appreciated. Ultimately, I would like to find the optimal "score" values in the following table:
age_LB | age_UB | score
20 | 29 | 20
30 | 39 | 30
40 | 49 | 40

A score gets assigned depending on the age of the person according to the values above. The dataset would look something like this:
name | age | GB | Score
peter | 21 | G | 20
jo | 31 | G | 30
mary | 41 | G | 40
sam | 21 | B | 20
paul | 31 | B | 30
jane | 41 | B | 40

Now what I need to do is to change the scores in the first table such that the following statistic is maximized:
(Mean_G - Mean_B)^2/(0.5*(Variance_G^2 + Variance_B^2))
where Mean_G is the mean score for the "G"'s, etc.

Also, there is also a criterion that the scores must not decrease as the age increases and they cannot be negative (e.g. the scores must go 20 < 30 < 40).

Any ideas on how to go about tackling this problem? Thanks very much!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 0 replies
  • 685 views
  • 0 likes
  • 1 in conversation