Hello! I have the following question. I am using SAS Enterprise Guide and I have the data structured like that: Client ID: Product: 1 A 1 B 2 A 2 D 2 C 3 B What I am trying to do is create binary variables for every product for every customer ID so that I can built a predictive model in SAS Enterprise Miner. I want the data to look like that: Client ID: Product A: Product B: Product C: Product 😧 1 1 1 0 0 2 1 0 1 1 3 0 1 0 0 The problem is that there are over 50 different products, and each client has different number of products and the ordinary functions are not working. Is there any other way to create that table with a query? Thank
... View more