Hello. I have the following problem that I need to solve. Let's suppose I have 2 variables (A and B) with 10 categories (ordinal most commonly) each containing nA1,...nA10,nb1,...nb10 clients each. I want to regroup these 10 categories into 3 categories called 1A, 1B and 1C (and for B:2A, 2B and 2C) and create a new variable lets say NEW_A and NEW_B. Now, the problem is to tell SAS to optimize the selection of these new subcategories of A in order to maximize the diagonal of NEW_A and NEW_B, so the selection of -let's suppose 1A- NEW_A will bring the most clients of 2A, 1B of 2B...etc.   So the selection need to be recursive. That's all I could figure so far and the key is to maximize number of clients.   All help is greatly appreciated.   Thanks! Jay     ... View more