https://communities.sas.com/t5/SAS-Enterprise-Guide/Optimization-of-single-value/m-p/55118#M5802 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:<BR /> age_LB | age_UB | score<BR /> 20 | 29 | 20<BR /> 30 | 39 | 30<BR /> 40 | 49 | 40<BR /> <BR /> A score gets assigned depending on the age of the person according to the values above. The dataset would look something like this:<BR /> name | age | GB | Score<BR /> peter | 21 | G | 20<BR /> jo | 31 | G | 30<BR /> mary | 41 | G | 40<BR /> sam | 21 | B | 20<BR /> paul | 31 | B | 30<BR /> jane | 41 | B | 40<BR /> <BR /> Now what I need to do is to change the scores in the first table such that the following statistic is maximized:<BR /> (Mean_G - Mean_B)^2/(0.5*(Variance_G^2 + Variance_B^2))<BR /> where Mean_G is the mean score for the "G"'s, etc.<BR /> <BR /> 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 &lt; 30 &lt; 40).<BR /> <BR /> Any ideas on how to go about tackling this problem? Thanks very much! Fri, 23 Jul 2010 18:22:01 GMT deleted_user 2010-07-23T18:22:01Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Optimization-of-single-value/m-p/55118#M5802 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:<BR /> age_LB | age_UB | score<BR /> 20 | 29 | 20<BR /> 30 | 39 | 30<BR /> 40 | 49 | 40<BR /> <BR /> A score gets assigned depending on the age of the person according to the values above. The dataset would look something like this:<BR /> name | age | GB | Score<BR /> peter | 21 | G | 20<BR /> jo | 31 | G | 30<BR /> mary | 41 | G | 40<BR /> sam | 21 | B | 20<BR /> paul | 31 | B | 30<BR /> jane | 41 | B | 40<BR /> <BR /> Now what I need to do is to change the scores in the first table such that the following statistic is maximized:<BR /> (Mean_G - Mean_B)^2/(0.5*(Variance_G^2 + Variance_B^2))<BR /> where Mean_G is the mean score for the "G"'s, etc.<BR /> <BR /> 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 &lt; 30 &lt; 40).<BR /> <BR /> Any ideas on how to go about tackling this problem? Thanks very much! Fri, 23 Jul 2010 18:22:01 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Optimization-of-single-value/m-p/55118#M5802 deleted_user 2010-07-23T18:22:01Z