Hi Reeza,   Hopefully this helps to explain things.    In this example, I currently have macros set up like the ones below.  However, I have to manually update these macros and re-run the SAS code for each of the 12 states that I need information for.  I would like to automate my SAS code to perform some sort of loop where the first time through the code it will use the AZ information listed below, then the second time through the code it will use the CA information listed below, and so on.   %let state='AZ'; %let parameter_values = ('AZGroup2','AZGroup4','AZGroup6) %let filename =Path\AZGroups   %let state='CA'; %let parameter_values = ('CAGroup1','CAGroup4','CAGroup7) %let filename =Path\CAGroups   Let me know if you need any other information that might help.   Thank you, Mike ... View more

Hi Reeza,   The ultimate goal is to include other variables as well.  I know procedure code might have been a little too simple, but I am looking to do the same thing with groups, subgroups, states, counties, etc.  When you add up the variables, it can get pretty tedious to continue to perform updates.   A lot of the information I have found on Do Loops runs calculations within the data set, or creates variables, but I have not seen a way to incorporate something like this into a Proc SQL Where function.   Thank you, Mike ... View more