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-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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
  • 1900 views
  • 0 likes
  • 2 in conversation