topic Re: Exploring Data in SAS enterprise miner. in SAS Data Science

Exploring Data in SAS enterprise miner.

ramazanunlu — Sun, 20 Sep 2015 19:16:57 GMT

I am new user in SAS enterprise miner and need help for something easy. I have a data set with one ID variable and nineteen predictors.

I need to find correlation coefficient values with target for each predictors.
Target value is 0 or 1, and let say one predictor has 4 level. I need to explore which level has how many 0 and 1 response (maybe creating an histogram.)

So far, I put the data in main diagram, then created StatExplore node, and run it. The results do not show what I need. You can see result in attached pic. Can anyone help?

Re: Exploring Data in SAS enterprise miner.

WendyCzika — Mon, 21 Sep 2015 17:17:20 GMT

Hi there,

It looks like the target has the level interval instead of binary. If you right-click on the Input Data node and select Edit Variables, you can change the level for your target to Binary there, then re-run the StatExplore node. Then in the Results under View>Summary Statistics, you can view the Class Variables: TARGET plot to see the distributions that you want, or the Cell Chi-Squares table.

Note that also from the Edit Variables window of the Input Data node, you can select all the variables and click on Explore. This will plot histograms for each individual variable, and these plots are interactive so you can click on the bar for one of the levels in the histogram for your target to see the distribution of the other variables just for that level.

Give that a try, and report back how that all goes!

Thanks,

Wendy

Re: Exploring Data in SAS enterprise miner.

mathew17 — Wed, 07 Oct 2015 11:33:50 GMT

The exploration of node relationships and patterns using data from an assortment of computations, charts, and graphs commonly used in SAS procedures

A step-by-step approach to each node discussion, along with an assortment of illustrations that acquaint the reader with the SAS Enterprise Miner working environment

Descriptive detail of the powerful Score node and associated SAS code, which showcases the important of managing, editing, executing, and creating custom-designed Score code for the benefit of fair and comprehensive business decision-making
Complete coverage of the wide variety of statistical techniques that can be performed using the SEMMA nodes