topic Re: sas macros in SAS Programming

sas macros

asuman — Tue, 03 Dec 2019 17:45:17 GMT

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.

Re: sas macros

Kurt_Bremser — Tue, 03 Dec 2019 17:52:54 GMT

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.

Re: sas macros

Tom — Tue, 03 Dec 2019 17:53:04 GMT

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.

Re: sas macros

asuman — Tue, 03 Dec 2019 17:55:32 GMT

Thanks Tom,This is what i was looking for.