topic Re: %if inside macro in SAS Programming

%if inside macro

Ivy — Wed, 23 Aug 2017 20:16:35 GMT

Hello,

May you help with what is wrong about following macro? Thank you. -Ivy

%macro t ;
%let group = 'SORAFENIB_1stline' ;

%if &group. in ( 'SORAFENIB_1stline' , 'commercial', 'Cirrhosis', 'meta') %then %do;
proc sql;
select count(distinct enrolid) into: cntt
from ads.cohort ;
quit;
%end;
%mend;

%t;

15 %macro t ;
16 %let group = 'SORAFENIB_1stline' ;
17
18 %if &group. in ( 'SORAFENIB_1stline' , 'commercial', 'Cirrhosis', 'meta') %then %do;
19 proc sql;
20 select count(distinct enrolid) into: cntt
21 from ads.cohort ;
22 quit;
23 %end;
24 %mend;
25
26 %t;
MLOGIC(T): Beginning execution.
MLOGIC(T): %LET (variable name is GROUP)
ERROR: Required operator not found in expression: &group. in ( 'SORAFENIB_1stline' , 'commercial', 'Cirrhosis', 'meta')
ERROR: The macro T will stop executing.
MLOGIC(T): Ending execution.

Re: %if inside macro

Reeza — Wed, 23 Aug 2017 20:25:17 GMT

MINOPERATOR

IN wasn't always supported in SAS macros, so when it was added to keep backwards compatibility it requires you to set the option.

You can check the docs on how the specifics work, but you can add it to your macro definition, which is the easiest option.

%macro t / MINOPERATOR;

Re: %if inside macro

Ivy — Wed, 23 Aug 2017 20:32:19 GMT

Thank you very much, Reeza .

Re: %if inside macro

Astounding — Wed, 23 Aug 2017 20:33:50 GMT

In addition, you will need to specify what delimiter the IN operator should use. A comma is permitted as the delimiter, but then you should not have spaces on either side of the commas in your %IF %THEN statement. The name of the global option is MINDELIMITER:

http://support.sas.com/documentation/cdl/en/mcrolref/69726/HTML/default/viewer.htm#n0vc5y2nyi55dvn1agla9j658kwh.htm

And you will need to get rid of the parentheses around the list of items. The macro language IN operator doesn't use them.