turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Data Mining
- /
- Is there a faster way to do variable transformatio...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

07-06-2017 06:46 AM

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,

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

07-06-2017 09:52 AM

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.