DATA Step, Macro, Functions and more

Using %local

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 138
Accepted Solution

Using %local

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!


Accepted Solutions
Solution
‎01-17-2013 10:27 AM
Super User
Posts: 11,343

Re: Using %local

Posted in reply to Walternate

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;


View solution in original post


All Replies
Solution
‎01-17-2013 10:27 AM
Super User
Posts: 11,343

Re: Using %local

Posted in reply to Walternate

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;


🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation