sas macros

[asuman]

Suppose there  is a table and in table ,a column named state has 28 different values.I want to call 5 states names, for this i want to write a single macro which will call those 5 states.

Kindly help.

[Kurt_Bremser]

You can use the "in" operator in where conditions, no macro needed.

To illustrate your issue, post example data in a data step with datalines (use the "little running man" icon for posting code), and what you expect to get out of it.

[Tom · Accepted solution]

It is not clear what you are asking for.  A simple example of what you have and what you want to get would help.

If you are looking to subset your data then a WHERE statement (not a macro or a macro variable) is what you want.

You could use a macro variable to help you generate the WHERE statement.

%let state_list = 'NY' 'CT' 'DE' ;
data want;
  set have;
  where state in (&state_list);
run;

An actual macro is not needed unless you need to do something more complex.

[asuman]

Thanks Tom,This is what i was looking for.