Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Transform back to normal range when viewing results Clustering SAS EM?

Reply
New Contributor
Posts: 4

Transform back to normal range when viewing results Clustering SAS EM?

Hello everyone,

I had a data set which had to be log transformed. After that i applied the clustering node and viewed the results. When viewing the output i cannot figure how to scale the variables back to dollar amounts so its understandable. For example in the segment plot, all the bars have ranges which are in log units. Is there a way to view the segment plot with the $ amounts? Thanks.

PROC Star
Posts: 7,468

Re: Transform back to normal range when viewing results Clustering SAS EM?

Posted in reply to hassan_masood90

If you used the log() function to do the transformation, can't you just use the exp() function to untransform them?

 

Art, CEO, AnalystFinder.com

 

New Contributor
Posts: 4

Re: Transform back to normal range when viewing results Clustering SAS EM?

Hi,

That is what i do before i attach the graph explore node and the segment profile node to the cluster node. However, for the cluster node itself, is there a way to view results as exponential values without having to attach a transformation node?

Occasional Contributor
Posts: 11

Re: Transform back to normal range when viewing results Clustering SAS EM?

Posted in reply to hassan_masood90

Plot a graph with your before transformed and after transformed variable... with that you can see where the scale and direction of the variable. If you want more details, create a table with before and transformed value side by side... then it can be easily compare. 

Ask a Question
Discussion stats
  • 3 replies
  • 167 views
  • 0 likes
  • 3 in conversation