Hi all, I am kindof new to SAS macros, and had a question about how to run a macro ovre and over, based on my macro variable.

As a simple example, say this was my macro:

%macro one; data &med.; set medicationlist; where drugname="&med."; run;

%mend

So, say I want to run this macro for 50 different drugs, which each have a unique drugname. Do I have to use a %let statement 50 times? My drug names are just drug1 drug2, etc. to drug50.

Thanks for any help you can give!