BookmarkSubscribeRSS Feed
to_the_point
Calcite | Level 5

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?  thanks

3 REPLIES 3
Ksharp
Super User

Maybe you can use RANK() to transform them into ASSIC code ,and bin them according to your rule .

to_the_point
Calcite | Level 5

Thanks Xia, but I'm unfamiliar with ASSIC code - do you have an example?

Ksharp
Super User

Sorry to confuse you . Use Rank() you can transform all these character into numeric value ,like 23 34 65 ...

This approache can directly bin your mixed-data like it is numeric .

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1497 views
  • 0 likes
  • 2 in conversation