Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

How to see correlation matrix in sas enterprise miner

Accepted Solution Solved
Reply
Contributor
Posts: 47
Accepted Solution

How to see correlation matrix in sas enterprise miner

Hi,

I wonder if you can please help me?

I am trying to perform some algorithms (Neural Network, SVM, Decision Tree and Random Forest) on my dataset. 
What I am trying to see is how can I get Correlation Matrix, Confusion Matrix when I apply Model Comparison Node.

 

Basic Flow of my diagram is as follow

 

Import >>>> Stat Explorer >>>> Data Partition >>>> ANN, SVM, HP Forest, DT>>>> Control Point >>>> Model Comparison

 

Could you also please suggest any suitable node or critaria which may give me more results with these 4 algorithms in terms of best model comparison and results.

 

Regards

 


Accepted Solutions
Solution
‎05-20-2017 02:49 AM
SAS Employee
Posts: 8

Re: How to see correlation matrix in sas enterprise miner

Hello,

 

Great Question. 

 

A correlation matrix can be obtained using the variable clustering node. 

Try attaching the model comparison node to the variable clustering node and then run the variable clustering node.  From the results screen, click view > Model >  Variable Correlation. 

correlation matrix.JPG

 

To surface the numeric values used to derive the graph, click on the Table shortcut button at the top right of the results screen.

 

An Event Classification Table is provided in the output window of the results in the Model Comparison node, which provides you the TN, FN, TP and FP counts.

 

With respect to the additional graphs or results, I find the model comparison node does a pretty good job.  I really enjoy examining the Lift chart provided by the model comparison node because the lift charts gives us a graphical representation of each model's performance over the prior, that is a random guess.

I hope this helps!

Best,

  Robert 

View solution in original post


All Replies
Solution
‎05-20-2017 02:49 AM
SAS Employee
Posts: 8

Re: How to see correlation matrix in sas enterprise miner

Hello,

 

Great Question. 

 

A correlation matrix can be obtained using the variable clustering node. 

Try attaching the model comparison node to the variable clustering node and then run the variable clustering node.  From the results screen, click view > Model >  Variable Correlation. 

correlation matrix.JPG

 

To surface the numeric values used to derive the graph, click on the Table shortcut button at the top right of the results screen.

 

An Event Classification Table is provided in the output window of the results in the Model Comparison node, which provides you the TN, FN, TP and FP counts.

 

With respect to the additional graphs or results, I find the model comparison node does a pretty good job.  I really enjoy examining the Lift chart provided by the model comparison node because the lift charts gives us a graphical representation of each model's performance over the prior, that is a random guess.

I hope this helps!

Best,

  Robert 

Contributor
Posts: 47

Re: How to see correlation matrix in sas enterprise miner

Thanks a lot Robert and sorry for late reply. 

I have followed your suggestion and it works perfectly for me..

 

 

Thanks again

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 497 views
  • 0 likes
  • 2 in conversation