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....
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;