topic Re: Clustering with both Numerics and Categories data in SAS EM 13.1 in SAS Data Science

Clustering with both Numerics and Categories data in SAS EM 13.1

Hue — Mon, 22 Feb 2016 09:17:40 GMT

Dear all,

I am making Customer segmentation. My data included numeric data (4 variables) and categories data (7 variables).

I used clustering method to classified customer.

If I transfer categories data to dummy and then use K-Means algorithms for new data, It make falsifying clustering result or not?

Could you advice to me the way that I can use to cluster for both Numeric and Categories data on SAS?

Thanks for your help!

Hue

Re: Clustering with both Numerics and Categories data in SAS EM 13.1

Ksharp — Tue, 23 Feb 2016 02:34:20 GMT

If you mixed up numeric and character variable , Check Generalized Logits Model (a multinomial model ).

Re: Clustering with both Numerics and Categories data in SAS EM 13.1

abuanuazu — Tue, 23 Feb 2016 03:39:19 GMT

Thank you for your solution to the problem.

Re: Clustering with both Numerics and Categories data in SAS EM 13.1

ilknurkabul — Wed, 24 Feb 2016 02:17:24 GMT

Clustering methods in EM convert nominal variables into dummy variables. There are different encoding techniques available in the cluster node. You can try those options and check the compactness of clusters. If you are using procs, you can also try PROC CLUSTER by using distance/similarity measures (such as jaccard).