Help using Base SAS procedures

Validate the output of goal seek in excel & SAS

Reply
New Contributor
Posts: 2

Validate the output of goal seek in excel & SAS

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

Esteemed Advisor
Posts: 5,529

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

Posted in reply to shekhar_148

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

PG
New Contributor
Posts: 2

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

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.
Ask a Question
Discussion stats
  • 2 replies
  • 327 views
  • 0 likes
  • 2 in conversation