I sketched out the logic for an example with 6 observations and one rule: if R1="V" and is 1 or 2  and if another R1="O" and is 4 or 5 and the above 2 things are true 1 time new rating=3 This logic is being performed on a table brought in from an Excel model which is why the logic isn't set up in a way conducive to SAS. In this example we have a table with 6 observations and a table with 1 observation. In the example I originally posted we have a table with 11 observations and a table with 4. It's less the logic and output I want advice on as it is how to compare tables that are fundamentally different sizes in SAS. ... View more

I'm using SAS enterprise to make a business deliverable, while I don't have direct server access (I'm literally the only person in my department that can program at all, making something for them to give to the systems people) I obviously would like it to work in a production environment so that other programmers don't have to waste their time redoing things.   No I didn't add the part with resolve in I will try that now. Will the macro variable approach not work in a server environment? ... View more