This is definitely close to what I am looking for, I am fairly new to SAS but it seems like I would have to put list all the unique variables in the code itself to be able to do this right, as well as the "associated value variable matching above". Is there any way I can just link this to an Excel Sheet, that way evry week or month that we update our data I can just run the query again and the updated list will populate? Also, is there any way I can add an if statement before the combinations start generating? I feel if I were to use an ifstatement before the combinations begin, I would be able to cut down the number of outputs since a lot of the combinations it will be generating will not satisfy the $ restriction. ... View more

I will give you an example based on what I am trying to model the my project as, using fantasy football as my example because I think I would be able to explain it better (Sorry if this is not what you were expecting as an example).   So in fantasy football you have $50,000 salary cap every week, you have to choose 7 players and each player is assigned a salary based on how he is projected to perform during the week. So the first step would be figure out the combination of players for each position that would reach to that $50,000 salary cap or under. Obviously I only want to choose 1 or 2 optimal lineups, but I my output is giving me thousands of rows as an output, so there is where I can start filtering my other rows as input. I could decide I want to filter by the highest total aggreggate fantasy points from last week, or filter out by the opponent they are playing next week. So that would reduce my total number of combinations from thousands to maybe hundreds. And then just keep applying filters on the data to try to reach my "optimal lineup" i guess. So I guess the first step would be having a formula that would create all those possible lineups that are <= $50,000 on salary. ... View more

Id say there will probably be around 150 customers. I was trying to do it in Excel with a sample of the data but unfortunately it was too much data to crunch. Ideally all I would need is to calculate all the possibel combinations on column A and then I would include some If Statements in my analysis to find the optimal solution. I was told I would be able to do this in SAS, so sorry if I made it seem like there were 1000s of customers. ... View more

We are trying to group these customers in "batches", so I am just trying to see how many combinations there are, and then optimize the combinations by using different parameters for the data (age, state, etc). I guess it is comparable to an optimal lineup in Draftkings. Once you have all the possible combinations of players that dont exceed the salary given, then you would rank the other fields on importance level to attempt to find your "optimal lineup" (sorry for the unnecessary Draftkings reference haha).   So at the end of the day, my output would a list of all possible combination of customer names given that column B does not exceed a total number. Then hopefully after that I can look at the other fields and find the most ideal method of batching.   Hope this provides a bit more insight on what I am trying to accomplish. ... View more