BookmarkSubscribeRSS Feed
frupaul
Quartz | Level 8

Hi all,

Is there an option one can use that will enable SAS Enterprise Miners do all variable transformations and choose the best transformation for each variables? I know about the BEST transformation, but that's not suitable for every type of variable.

 

Does one need to transform one variable at a time, check distribution (or distance statistics)  to see if transformation produced desired results before moving forward with the other data preparation tasks? Does SAS EM not have a faster option? (SOrry for the repitition)

Thanks,

 

 

 

 

1 REPLY 1
WendyCzika
SAS Employee

I"m not sure why you say Best isn't suitable for every variable - if you choose Best from the Transform Variables node, it will try several transformations for each variable (Log, Log10, Sqrt, inverse, square, exp, standardized, range) and choose the one for each variable that is most correlated with the target.  Alternatively, you can pick Maximum Normal, Maximum Correlation, Equalize, Optimal Max. Equalize for it to try several Box-Cox power transformations and then pick the best for each variable in terms of what you pick to maximize.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 1 reply
  • 694 views
  • 0 likes
  • 2 in conversation