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
- /
- Data Mining
- /
- How to cross a Response Model with Demand Model ?

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
- Highlight
- Email to a Friend
- Report Inappropriate Content

08-03-2016 01:27 PM

I have created 2 models, 1 to predict Response, and 1 to predict Demand - I want my final score to be the cross of the 2 (predicted resp * predicted demand) I have done this in SAS Code, however, in my new position, I have been asked to use Enterprise Miner -and I have zero experience. I have managed to follow a few of the tutorials, and use my past experience to get to the point I want with the Models, just don't know how to implement.

Thanks for any guideance

Tammy

Accepted Solutions

Solution

08-08-2016
01:52 PM

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

Posted in reply to TMiles

08-06-2016 06:26 PM

Hi,
1. Your single order model vs multiple order model are just segmentation. If you know how to do one, you should be able to work out the other.
2. When your third model is labeled as resp=1, I understand you want to build the demand/linear reg only on those who have responded and have legit $ order amount. That makes sense. But your label suggests it is a logistic regression. It probably should be a liner Reg. So now you should have one linear demand for those who only responded and had one order. Another demand model for the group that have responded and have >1 orders. In other words, you should have two logistic model *demand.
You can connect Model Comparison node to each of the three models you displayed in your screen print, to easily assess model performance. BUT, the Model Comparison node is normally used to compare when the model universe is the same/held fixed. For example, for the same 1 order universe, you like to compare decision tree model, with logistic regression model, you use Model Comparison Node. You should NOT use MC node to compare a model built on 1 order universe and another built on multiple orders.
To access Score code, click on the logistic regression node of your interest, right mouse click. In the resulting drop down menu, select Results. On the pop up dialog screen, go to up left corner, see View menu? You should see Score code from there.

All Replies

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

Posted in reply to TMiles

08-05-2016 10:07 AM

Hi,
In EM, there are two kinds of ways you can replicate what you did in SAS Code (I imagine that might be BASE +STAT/R). One way is EM's built in node Two-Stage Node. Since you are just starting with EM, I would suggest leave this node alone for now since it has quite a bit built facility that takes a bit time to get used to, although it does conceptually matches what you want.
The other way is to just use Regression node to try to replicate your demand model. You can use the same Reg node to replicate the response model. In EM, you set the Target variable type to be binary. Reg node will fit classification model for you. If you set it as interval target, it will fit a linear regression for you. It is decided automatically. Once you finish the two models, go fetch automatically generated SAS Code for scoring, one piece for each model. They are created by each node respectively. They you copy them together. Sound like you are well versed in SAS code. You can cross the two model scores and get your probability adjusted demand. Hope this helps? Thanks for using SAS. Jason Xin

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

Posted in reply to JasonXin

08-05-2016 06:16 PM

Thank you for responding -I'm still confused on how to do what you suggest. I am attaching a screen print of what the diagram looks like. I want to conditionally generate the Resp Model, then create a Demand model. So each ID will have 2 scores that I will ultimately multiply for a final score and ranking.

Would I do the Compare Model 3 times? How do I get the Score Code? Sorry for all the questions, , my deadline is close and i feel like I am spinning my wheels.

Solution

08-08-2016
01:52 PM

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

Posted in reply to TMiles

08-06-2016 06:26 PM

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

Posted in reply to JasonXin

08-08-2016 12:59 PM

Thank you -I have gotton that far so do I just add a SAS Code Node and paste in the code and the add the logic to create the Cross of of the 2 scores for each segment (1-time purchasers vs Multi)? That almost sounds to simple...

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

Posted in reply to TMiles

08-08-2016 01:39 PM

I am glad you are making progress. The point of having GUI system like EM is to free modelers from activities like writing score code to focus on building predictive assets, design, testing and communications. That is how your core competency is supposed to be used.
Thanks. Jason Xin