I have many variables that I need to run through the same series of procedures--such as a proc freq, multiple proc phregs, proc means, and a proc univariate. In order to accomplish this, I have been using a macro variable, for example: %let myvariable=grams_fruit followed by my various procedures, such as proc freq data=mydata; tables age*&myvariable / chisq; where &myvariable ne 0; run; proc means data=mydata; var age; class &myvariable; run; and so on. Then, I would run the let statement again with the next variable (%let myvariable=grams_veg), and run all of my procedures again. Is there a better way to do this, where I can loop my list of variables to be used in this series of procedures? It is important that all of these procedures produce results for one variable (eg grams_fruit) before moving on to the next.
... View more