check if multiple appended column values match values in another dataset

[Reeza]

---

@RTelang wrote:

@RW9 yes creating my own set of macros to perform certain specific function..So i do the base code then convert it into a generic macro, i.e to call the macro & perform its intended function instead of writing the code again & again.... in the above code am stuck at the point to check if specific unique values are matching particular values in both datasets... 

---

If this is the case post your base code. 

But again, you're doing thing inefficiently. At some point this will come back to bite you. 

Look ok at the documentation for SAS 9.4 macros for examples on how to loop macro variables.