BookmarkSubscribeRSS Feed
JovanaUniCredit
Calcite | Level 5

Hi community!

I have to do a categorization for continuous factors (e.g. using deciles, or different intervals consistent with the sample size) in order to provide more stability to the analysis of their relation with the target variable (which is not binary, but interval one).

If I decide to use deciles, each bucket should be composed by at least 30 observation in order to perform following discriminatory power test.

 

Is it possible to be done in Enterprise Miner?

 

I saw that there is Interactive Binning node, where interval target variable is converted to binary one. Is it correct to use this node, or there is other node more appropriate for this task?

 

In addition to this, if it is not possible to be done in Enterprise Miner, how it can be done in SAS EG?

 

P.S. If this is not correct forum to ask this question, please tell me which one is in order to get answer.

 

Thank you, Jovana

1 REPLY 1
gcjfernandez
SAS Employee

The following SAS Resources can be helpful:

 

Optimal Binning in SAS enterprise miner:

https://communities.sas.com/t5/SAS-Data-Mining-and-Machine/Optimal-Binning-in-the-Enterprise-Miner-T...

https://support.sas.com/resources/papers/proceedings15/SAS1965-2015.pdf

 

 

Interactive grouping in SAS Enterprise miner (Credit scoring license)

https://go.documentation.sas.com/doc/en/emref/14.3/p1qzwz7onopjqcn11uc04i18urg7.htm

 

Using HPBINN proc

https://blogs.sas.com/content/iml/2019/08/05/proc-hpbin-bin-variables-sas.html

 

The ideal method of binning depends on your analytical objectives, the properties of input variables and the target variable

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 339 views
  • 0 likes
  • 2 in conversation