topic Re: Validate the output of goal seek in excel & SAS in SAS Procedures

Validate the output of goal seek in excel & SAS

shekhar_148 — Mon, 28 Aug 2017 17:48:42 GMT

Hi All,

I am trying to validate the output of goal seek in excel and SAS, But both outputs are different. I am looking for help. I have attached the excel calculation. I tried the same with proc model but i am not getting the same output. Pls help me....

Re: Validate the output of goal seek in excel & SAS

PGStats — Mon, 28 Aug 2017 18:08:44 GMT

Please express your problem in math terms and show the SAS code you used. Reverse engineering an Excel sheet is no fun at all.

Re: Validate the output of goal seek in excel & SAS

shekhar_148 — Mon, 28 Aug 2017 18:21:10 GMT

I have a data set in that variables are 3 variables are: Score_Rating, No_Of_Customer,No_Of_Customer_Percentage.
Now Calculated terms are:
Modified_model=slop * Score_Rating + intercept.
Calibrated_PD= exp(Modified_model)/(1+Modified_model)
PIT=No_Of_Customer_Percentage * Calibrated_PD;

Then take the sum of PIT as final PIT Number.

Pls refer the below code.
data pit;
set pit_pd;
tot_cust=10491;
slope=0.4359;
PIT=0.0259;
run;

proc model data=pit;
pit=(cust/tot_cust)*(exp(slope * Pool_ID +intcpt)/(1+exp(slope * Pool_ID + intcpt)));

fit pit /outest=test3 ;
solve pit /data=pit out=test4;
run;

In the excel i am fixing the value if PIT and find out the value of intercept.