Using %local

[Walternate]

Hello,

I am trying to create tables for each of my demographic variables along with whether a person is a case or a control.

This is what I have:

%local varlist;

%let varlist=age race sex etc;

proc freq data=my_data;

tables &varlist;

tables case*&varlist/chisq;

run;

Case indicates whether someone is a case or a control. The individual tables printed fine, and a table showing age by case/control status, but then the program stopped incorporating case/control status and just reprinted the overall frequencies for race, sex, etc.

Any help is much appreciated!

[ballardw · Accepted solution]

To use the composite (my term) table syntax with a group of variables they need to be in ().

Your second table statement should be :

tables case * (&varlist) / chisq;