topic binning approach for variables with mixed types in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/binning-approach-for-variables-with-mixed-types/m-p/162556#M1773 <HTML><HEAD></HEAD><BODY><P>Hi, does anyone have any insight on an approach to binning multiple variables with mixed data types - for example: variable A can take the value A, B, C, D, E or any number 1-1000 - I've seen approaches that directly bin numeric or character variables but not one that deals with both types in one variable - any ideas?&nbsp; thanks</P></BODY></HTML> Wed, 11 Feb 2015 07:02:13 GMT to_the_point 2015-02-11T07:02:13Z binning approach for variables with mixed types https://communities.sas.com/t5/SAS-Data-Science/binning-approach-for-variables-with-mixed-types/m-p/162556#M1773 <HTML><HEAD></HEAD><BODY><P>Hi, does anyone have any insight on an approach to binning multiple variables with mixed data types - for example: variable A can take the value A, B, C, D, E or any number 1-1000 - I've seen approaches that directly bin numeric or character variables but not one that deals with both types in one variable - any ideas?&nbsp; thanks</P></BODY></HTML> Wed, 11 Feb 2015 07:02:13 GMT https://communities.sas.com/t5/SAS-Data-Science/binning-approach-for-variables-with-mixed-types/m-p/162556#M1773 to_the_point 2015-02-11T07:02:13Z Re: binning approach for variables with mixed types https://communities.sas.com/t5/SAS-Data-Science/binning-approach-for-variables-with-mixed-types/m-p/162557#M1774 <HTML><HEAD></HEAD><BODY><P>Maybe you can use RANK() to transform them into ASSIC code ,and bin them according to your rule .</P></BODY></HTML> Wed, 11 Feb 2015 07:23:05 GMT https://communities.sas.com/t5/SAS-Data-Science/binning-approach-for-variables-with-mixed-types/m-p/162557#M1774 Ksharp 2015-02-11T07:23:05Z Re: binning approach for variables with mixed types https://communities.sas.com/t5/SAS-Data-Science/binning-approach-for-variables-with-mixed-types/m-p/162558#M1775 <HTML><HEAD></HEAD><BODY><P>Thanks Xia, but I'm unfamiliar with ASSIC code - do you have an example?</P></BODY></HTML> Wed, 11 Feb 2015 08:20:39 GMT https://communities.sas.com/t5/SAS-Data-Science/binning-approach-for-variables-with-mixed-types/m-p/162558#M1775 to_the_point 2015-02-11T08:20:39Z Re: binning approach for variables with mixed types https://communities.sas.com/t5/SAS-Data-Science/binning-approach-for-variables-with-mixed-types/m-p/162559#M1776 <HTML><HEAD></HEAD><BODY><P>Sorry to confuse you . Use Rank() you can transform all these character into numeric value ,like 23 34 65 ...</P><P>This <SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"> approache can directly bin your mixed-data like it is numeric .</SPAN></P></BODY></HTML> Wed, 11 Feb 2015 08:37:47 GMT https://communities.sas.com/t5/SAS-Data-Science/binning-approach-for-variables-with-mixed-types/m-p/162559#M1776 Ksharp 2015-02-11T08:37:47Z