topic Re: Creating a Macro that populates a set within PROC SQL in SAS Programming

Creating a Macro that populates a set within PROC SQL

Jeremy_Wade — Mon, 22 Aug 2016 16:21:37 GMT

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 — Mon, 22 Aug 2016 17:16:46 GMT

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

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 — Mon, 22 Aug 2016 20:16:07 GMT

Awesome, Thanks!