BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
elkinsbe
Obsidian | Level 7

Is there a way of saving the cluster membership as a variable and subsequently add that variable to a table? That would be extremely valuable insight in a current report I am building.

Alternatively, is there a way to create an action between a table and a cluster analysis such that selecting a row in the table will highlight the cluster that they have been assigned??

 

I'm just trying to use this cluster analysis - in a manner that will call out actionability.... 

Thank you all in advance for your assistance.

1 ACCEPTED SOLUTION

Accepted Solutions
Stu_SAS
SAS Employee

Hey @elkinsbe! This is one of my favorite features of Visual Analytics - you absolutely can add those clusters to a table and even assign clusters to new data automatically. Visual Analytics has built-in scoring methods for its models. Models that you create in Visual Analytics can be scored directly within the report - no extra code needed. Here's how easy it is with a clustering model.

 

  1. Right-click the clustering model and select "Derive cluster ID items..."
    Stu_SAS_0-1675348216681.png
  2. In the pop-up box, give the variables a name. Cluster ID will be a variable that identifies the cluster a particular row belongs to. You also get some other statistics, such as distance from the cluster centroid. This helps you identify where the observation lies compared to the cluster centroid.
    Stu_SAS_1-1675348350315.png

     

  3. Check the data pane. You should now see your derived clusters there:
    Stu_SAS_2-1675348420291.png

That's all there is to it! You can add these data items to any visualization you see fit in Visual Analytics. As new data comes in for this table, they'll be assigned a cluster automatically based on your model.

Stu_SAS_3-1675348651152.png

 

Whenever you model in Visual Analytics, right-click and look for "Derive predicted..." or some variation of that. That's your way to add your model predictions directly to a report. The beautiful thing about it is that a data scientist can create a model in a report, hand it off to a report designer, and the report designer doesn't need to know how the model works. They can work with the predictions exactly like any other data item.

 

 

View solution in original post

2 REPLIES 2
Stu_SAS
SAS Employee

Hey @elkinsbe! This is one of my favorite features of Visual Analytics - you absolutely can add those clusters to a table and even assign clusters to new data automatically. Visual Analytics has built-in scoring methods for its models. Models that you create in Visual Analytics can be scored directly within the report - no extra code needed. Here's how easy it is with a clustering model.

 

  1. Right-click the clustering model and select "Derive cluster ID items..."
    Stu_SAS_0-1675348216681.png
  2. In the pop-up box, give the variables a name. Cluster ID will be a variable that identifies the cluster a particular row belongs to. You also get some other statistics, such as distance from the cluster centroid. This helps you identify where the observation lies compared to the cluster centroid.
    Stu_SAS_1-1675348350315.png

     

  3. Check the data pane. You should now see your derived clusters there:
    Stu_SAS_2-1675348420291.png

That's all there is to it! You can add these data items to any visualization you see fit in Visual Analytics. As new data comes in for this table, they'll be assigned a cluster automatically based on your model.

Stu_SAS_3-1675348651152.png

 

Whenever you model in Visual Analytics, right-click and look for "Derive predicted..." or some variation of that. That's your way to add your model predictions directly to a report. The beautiful thing about it is that a data scientist can create a model in a report, hand it off to a report designer, and the report designer doesn't need to know how the model works. They can work with the predictions exactly like any other data item.

 

 

elkinsbe
Obsidian | Level 7
Bravo! Bravo! -- The SAS Communities are so fantastic!! Every time I need support you are there with a helpful solution!! Many thanks!!!

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 501 views
  • 1 like
  • 2 in conversation