Hi, I have built a logistic regression model to predict customers who are more likely to click on a marketing offer. My model is not great as I have a AUC=0.58 and 50% capture only 60%. So I have built the model on a training sample  (9 months) then kept 2 months of data as sample held out from model dev (Validation) to test my prediction. Once I finished to build the model on the training, I have scored the validation (2 months dataset) then sorted the scored validation, and sliced the target variable and probabilities into deciles ..like below...It doesn't seem that my model is ranking well ...Is it because the AUC is low..so the predictive power is not great?  Your help will be much appreciated....Many Thanks proc rank data=VALIDATION (KEEP=CLICK_FLAG EM_EVENTPROBABILITY) groups=10 out=pred_valid;   var EM_EVENTPROBABILITY; ranks decile; run; data pred_valid;   set pred_valid; decile=decile+1; run; proc sort data=pred_valid; by descending EM_EVENTPROBABILITY; run; proc means data=pred_valid n mean sum;   var CLICK_FLAG;   class decile; run; proc means data=pred_validn mean sum; var EM_EVENTPROBABILITY; class decile; run; Decile Training Response Rate Training Mean_Score Validation Response Rate Validation Mean_Score 10 10% 0.10 6% 0.10 9 9% 0.08 6% 0.08 8 7% 0.07 7% 0.07 7 6% 0.06 7% 0.06 6 6% 0.06 7% 0.06 5 6% 0.06 7% 0.06 4 6% 0.05 7% 0.05 3 5% 0.05 6% 0.05 2 5% 0.05 5% 0.05 1 4% 0.03 7% 0.03 ... View more

Hi All, Could you please let me know how to get the VIF in Enterprise Miner..I couldn't find it anywhere....Your help will be much appreciated as it is quite urgent... I know how to calculate in SAS Base but the current company I work build models in Enterprise Minre 7.1 only. Many Thanks Alice ... View more

Hi All, The model I am building has a low response rate, what are the characteristics of a Good Model in this case...It is clear that there is no point to look at the accuracy because it will be high anyway. AUC value,Gini,Lift Curve are they still indicators of a good model? Or is there any better way, to check the model perfomance in this case? Many Thanks ... View more

Hi, I have a poulation (A+B) of 1,812,507 customers. I would like to take a sample and stratify by the variable Decile. I want to take all the customers in Targeting A and take a sample of the people in Targeting B and make sure that the proportion of the variable decile in Targeting B is similar to the proportion of  the varaible decile in Targeting A...For example for decile 0, I would like to get a proportion of 4% in Targeting B, at the moment is 7% (Please see reports below). I am not sure how to proceed in Enterprise Miner...Your help will  be really much appreciated. Many Thanks   Targeting Decile Frequency Percent A+B 0 107,947 6% A+B 1 125,467 7% A+B 2 137,295 8% A+B 3 148,162 8% A+B 4 162,287 9% A+B 5 179,042 10% A+B 6 202,198 11% A+B 7 226,884 13% A+B 8 259,218 14% A+B 9 264,007 15% Total          1,812,507     Targeting Decile Frequency Percent A 0 30,377 4% A 1 35,011 5% A 2 44,019 6% A 3 62,457 9% A 4 68,468 10% A 5 75,773 11% A 6 85,504 12% A 7 95,146 14% A 8 103,738 15% A 9 94,490 14% Total 694,983                                                               Targeting Decile Frequency Percent B 0 77,570 7% B 1 90,456 8% B 2 93,276 8% B 3 85,705 8% B 4 93,819 8% B 5 103,269 9% B 6 116,694 10% B 7 131,738 12% B 8 155,480 14% B 9 169,517 15% Total 1,117,524 ... View more