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

[StaticFX]

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'")

[AhmedAl_Attar]

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

[StaticFX]

that simple?

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

[Reeza · Accepted solution]

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'")

---

[StaticFX]

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

[Tom]

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')