topic Re: SAS Macro %if %then %do %else %do in SAS Programming

SAS Macro %if %then %do %else %do

park2039 — Thu, 16 Aug 2018 15:24:54 GMT

I am trying to execute the following macro. Can someone explain why both conditions at the bottom are FALSE?

Thanks

%macro run_mig (yr);

data one;

%if &yr in (2015,2016) %then %do;

set "/y/x/&yr/vs&yr._1yr" ;

%end;

%else %if &yr le 2014 %then %do;

set "/y/x/&yr/data/vpers&yr._1yr" ;

%end;

run;

%mend;

%run_mig(2015);

MLOGIC(RUN_MIG): Beginning execution.

MLOGIC(RUN_MIG): Parameter YR has value 2015

MPRINT(RUN_MIG): data one;

MLOGIC(RUN_MIG): %IF condition &yr in (2015,2016) is FALSE

MLOGIC(RUN_MIG): %IF condition &yr le 2014 is FALSE

Re: SAS Macro %if %then %do %else %do

Reeza — Thu, 16 Aug 2018 15:34:17 GMT

IN doesn't always work as expected with the logic.

You can enable it using MINOPERATOR.

%macro run_mig(yr) / minoperator mindelimiter=',';

Or use OR

 %if &yr=2015 or &yr=2016 %then %do;

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

Re: SAS Macro %if %then %do %else %do

gamotte — Thu, 16 Aug 2018 15:34:44 GMT

I think the default delimiter for the in operator in macros is the space.

Try

option mindelimiter=",";

Re: SAS Macro %if %then %do %else %do

Astounding — Thu, 16 Aug 2018 15:35:54 GMT

Using the IN operator in macro language is tricky, and requires the proper setting for two options, and possibly a slightly different syntax. While you can look them up if you would (start with MINDELIMITER), it's easier to just get rid of IN for two possible values:

%if &yr=2015 or &yr=2016 %then %do;

Re: SAS Macro %if %then %do %else %do

park2039 — Thu, 16 Aug 2018 15:49:16 GMT

Reeza,

OR option worked. The other option minoperator mindelimiter=',' generated the following errors;

ERROR: The /MINDELIMITER= option must be a single character enclosed in single quotation marks.
ERROR: A dummy macro will be compiled.

Thanks