multiple clusters on the different data with single dataset

[husseinmazaar]

Dears,

I have dataset with three columns as follows:

CustomerID -  ID - nominal

Profit           -  Input- interval

Sector         - ...... - interval

I need to do clustering using profit column for each sector, this mean the clustering results should include all sectors and each sector has his clusters. Sector has values {1,2,3,...,420} 

I need to do this using SAS Enterprise Miner 13.2.

I appreciate your assistance.

[WendyCzika · Accepted solution]

You should be able to use the Group Processing nodes (Start Groups and End Groups) to do this: set up the flow:

Input Data > Start Groups > Cluster > End Groups, and in the Start Groups node, open the Variables editor and set the Grouping Role for Sector to Stratification.  You might need to set the Level of Sector to Nominal first in the Input Data node.

[husseinmazaar]

Thanks Wendy so much.