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 use Model comparison node in SAS Enterprise...

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

04-06-2016 02:30 PM

I am trying to build a model on an Interval target using SAS Enterprise Miner (v. 13.2) using Log transformation of the target and using the Linear Regression.

I have segmented the population based on different characteristics (like Low/High-income customers as model 1&2 and Male/Female customers as model 3&4) and ran a model for each segment.

Now trying to come up with the best segmentation based on the model outputs, I would like to use model comparison node to compare the fit statistics. the problem is, I cannot find a way to merge the segments together (1&2) vs. (3&4) so that I can compare the performance of the models together (Gender vs. Income level).

I used the "Append" node to merge two segments on each model but not successful.

I appreciate any help.

Sam

Accepted Solutions

Solution

04-08-2016
10:40 AM

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

Posted in reply to LinusH

04-07-2016 12:31 PM

Hi,
What you can do is to build a segment variable, say, segment_model by consolidating your segmentation logic. For example,
if Gender = "F" and income="low", then segment_model=1; else
if Gender = "F" and income="mid", then segment_model=2; else
if Gender = "F" and income="high", then segment_model=3;...
just build all the segmentation combinations into one variable.
After reading the data set into EM, turn this new variable segment_model's role into Segment. Make sure there is only ONE variable acting as Segment Role.
Then look into EM online example under START and END group. You should learn how to build models on this segment variable quickly. Then after END group you can connect Model Comparison Node. The Comparison node will report model statistics by the segments.
You can always run the model based on the whole sample alongside this START-END group process. Hope this help? Jason Xin

All Replies

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

Posted in reply to Sam_zirak

04-07-2016 03:03 AM

Moved to the appropriate Data Mining forum.

Data never sleeps

Solution

04-08-2016
10:40 AM

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

Posted in reply to LinusH

04-07-2016 12:31 PM

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

Posted in reply to JasonXin

04-08-2016 10:44 AM - edited 04-08-2016 10:44 AM

It works very well.

I cannot thank you enough for your guidance Jason.

Using start and eng groups is something I had never heard of before and it is incredibly powerful and time-saving. That is exactly what I was looking for and it will save me a huge amount of time on any project that I work on.

Thanks a million!

Sam