topic Re: Pass in a "Where" into a %Macro...? in SAS Programming

Pass in a "Where" into a %Macro...?

StaticFX — Wed, 29 Nov 2017 16:14:13 GMT

Is it possible to pass in a Where? like...

%macro test(where);

proc sql;
   create table temp as
   select field1, field2 from tableA where &where;
quit;

%mend test;

%test("ap_period='1234'")

Re: Pass in a "Where" into a %Macro...?

AhmedAl_Attar — Wed, 29 Nov 2017 16:18:16 GMT

Yes, but you will need to change your SQL into
where %unquote(&where);

Re: Pass in a "Where" into a %Macro...?

StaticFX — Wed, 29 Nov 2017 16:20:05 GMT

that simple?

lol guess i shouldve tried it first! Thanks! testing now

Re: Pass in a "Where" into a %Macro...?

Reeza — Wed, 29 Nov 2017 16:23:45 GMT

Yes, but slightly easier if you use WHERE =

e.g

%macro test(where=);

proc sql;
   create table temp as
   select name, age from sashelp.class where &where;
quit;

%mend test;

%test(where= age=15);

@StaticFX wrote:

Is it possible to pass in a Where? like...

%macro test(where);

proc sql;
   create table temp as
   select field1, field2 from tableA where &where;
quit;

%mend test;

%test("ap_period='1234'")

Re: Pass in a "Where" into a %Macro...?

StaticFX — Wed, 29 Nov 2017 16:46:10 GMT

Bingo! the first way didnt quite work.. this works perfectly thanks!!

Re: Pass in a "Where" into a %Macro...?

Tom — Wed, 29 Nov 2017 16:58:02 GMT

Just wrap your condition inside of parentheses instead of quotes.

%test((ap_period='1234'))

Also note that you can use named parameters in the macro call, even if the macro has it defined as a positional argument.

You just can't try to pass a value by position when the parameter is defined as named in the %macro statement.

%test(where=ap_period='1234')