Creating a Macro that populates a set within PROC SQL

[Jeremy_Wade]

Is it possible to replace this statement within PROC SQL:

case when variable in ('1', '2', '3', '4') then ....

with a macro of the form

case when variable in (%macroname(4)) then ...

So the macro would populate the set with the positive integers (in character form) 1 through 4 (or any positive number in place of 4).

Thanks, and sorry if this has been asked before.

[Astounding · Accepted solution]

While it is very possible in any case, it is easier if you are willing to:

• Use double quotes instead of single quotes
• Skip the commas entirely (the WHERE clause should work either way)

Here is one possible approach using the simplifying assumptions above:

%macro macroname (limit);

%local i;

%do i=1 %to &limit;

   "&i"

%end;

%mend macroname;

[Jeremy_Wade]

Awesome, Thanks!