https://communities.sas.com/t5/SAS-Data-Science/Change-levels-of-ordinal-variables/m-p/388802#M5872 <P>Hi. I was wondering whether there is a way in SAS Miner to group certain levels of ordinal variables. If one of my input variable is, for instance, "Number of Employee" and is stored as in 1-4, 5-9, 10-14 etc bins, is there a way to have Miner somehow group some of these levels, so that to have 1-9, 10-20. Even better, is there a way to have levels changed by Miner to find bins that would have better statistical significance (like 1-7, 7-18 etc...) in predicting the target (binary in this case)? For now, I do it ahead of my model in Guide but the choice of new levels is entirely based on my magic’s skill:) Many thanks. Nicolas</P> Thu, 17 Aug 2017 13:56:14 GMT NicolasC 2017-08-17T13:56:14Z https://communities.sas.com/t5/SAS-Data-Science/Change-levels-of-ordinal-variables/m-p/388802#M5872 <P>Hi. I was wondering whether there is a way in SAS Miner to group certain levels of ordinal variables. If one of my input variable is, for instance, "Number of Employee" and is stored as in 1-4, 5-9, 10-14 etc bins, is there a way to have Miner somehow group some of these levels, so that to have 1-9, 10-20. Even better, is there a way to have levels changed by Miner to find bins that would have better statistical significance (like 1-7, 7-18 etc...) in predicting the target (binary in this case)? For now, I do it ahead of my model in Guide but the choice of new levels is entirely based on my magic’s skill:) Many thanks. Nicolas</P> Thu, 17 Aug 2017 13:56:14 GMT https://communities.sas.com/t5/SAS-Data-Science/Change-levels-of-ordinal-variables/m-p/388802#M5872 NicolasC 2017-08-17T13:56:14Z https://communities.sas.com/t5/SAS-Data-Science/Change-levels-of-ordinal-variables/m-p/388808#M5873 <P>I don't know the answer.</P> <P>&nbsp;</P> <P>I do know that almost any type of predictive modeling will work better if you use the un-binned data instead of the binned data. Just something to thing about.</P> Thu, 17 Aug 2017 14:14:51 GMT https://communities.sas.com/t5/SAS-Data-Science/Change-levels-of-ordinal-variables/m-p/388808#M5873 PaigeMiller 2017-08-17T14:14:51Z