I have a very large program with approximately 40 variables. For the sake of argument, let's call them var1-var40. I need to know how many duplicates there are for var1, var1 and var2, var1 var2 and var3, var1 var 2 var3 and var4, ........., var1 var2 var3 ...... var 40. Is there a way to create this array without having to manually type it, and then recursively run it through a proc sort or proc SQL command so that I can see how many duplicates there are side by side for each of the combinations above. Currently, I am running 40 proc SQL statements, following by 40 proc freq commands on the individual outputs and manually checking them against each other. I feel there must be a way to incorporate an array with each variable combination into a do loop that automatically generates and stores the number of detected duplicates. Bonus points if the above code could show me which observations are dropping at each point as the combinations increase in variable size. Thanks in advance, Zach
... View more