turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Stat Procs
- /
- How to create a predictive model using test and t...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-11-2017 08:53 AM - edited 05-11-2017 09:10 AM

Hello all,

I want to create a basic model which would identify/predict customers those are eligible to get the loan so that these customers would be targeted by the customer care people.

Please find the attachments for sample documents. I am new to modelling , so i would like to know how this can be done in SAS.

And i want to automate this finally to run on weekly/monthly basis.

Thank you.

Vish

Accepted Solutions

Solution

05-12-2017
03:08 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Vish33

05-11-2017 10:29 AM

Assuming that your response is binary (eligible vs not), you would be fitting a logistic model. You can use PROC LOGISTIC to fit the model and the SCORE statement in that procedure to get predicted probabilities of eligibility for you test data set. See the LOGISTIC documentation and examples there such as the "Scoring data sets" example. Basic code would be like:

proc logistic data=train;

model binary_response(event="Y") = predictor1 predictor2;

score data=test out=mypreds;

run;

All Replies

Solution

05-12-2017
03:08 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Vish33

05-11-2017 10:29 AM

Assuming that your response is binary (eligible vs not), you would be fitting a logistic model. You can use PROC LOGISTIC to fit the model and the SCORE statement in that procedure to get predicted probabilities of eligibility for you test data set. See the LOGISTIC documentation and examples there such as the "Scoring data sets" example. Basic code would be like:

proc logistic data=train;

model binary_response(event="Y") = predictor1 predictor2;

score data=test out=mypreds;

run;

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to StatDave_sas

05-11-2017 10:44 AM

Thank you for your inputs. I will look into the Logistic documentation.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Vish33

05-12-2017 09:19 AM

Also you could try Decision Tree.

Check PROC HPSPLIT example .