Hi all, I have a dataset, including 1000 clients corresponding 1000 loans differently. I'd like to split 1000 clients to 50 groups with condition is total loans amount and the number of clients of each group equally? Could you help me solve this calculation by SAS EG? Cust_ID Loan_amt ($) A 10 B 20 C 15 D 58   Thanks alot, ... View more

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   ... View more