topic Re: Using IN operator with %IF %THEN %ELSE in SAS Programming

Using IN operator with %IF %THEN %ELSE

kingCobra — Thu, 14 Sep 2017 11:35:07 GMT

Hi,

Is there a way to use IN operator with %IF similar to what we do in data step IF THEN ELSE?

So for eample I need to use

%macro xxxxx(param= );

%IF &param. IN (A,B,C) %THEN %DO;

.........................

%END;

%ELSE %IF &param. IN (E,F,G) %THEN %DO;

....................

%END;

%mend;

%xxxxxx(param=A);

%xxxxxx(param=G);

Re: Using IN operator with %IF %THEN %ELSE

RW9 — Thu, 14 Sep 2017 11:47:13 GMT

Try:

http://support.sas.com/kb/35/591.html

However there doesn't seem to be much reason to do it this way. Your macro is just a complicated way of avoiding doing Base SAS. Post some real example code and will describe further.

Re: Using IN operator with %IF %THEN %ELSE

Astounding — Thu, 14 Sep 2017 11:50:54 GMT

Yes, but it looks a little different. At a minimum, parentheses should not be used.

Read up on two options: minoperator and mindelimiter.

If you set the MINDELIMITER option to |, you would use:

%if &param. in A|B|C %then %do;

You are allowed to use a comma as the value of MINDELIMITER, but that's not a requirement. Do not leave extra spaces on either side of your delimiter.

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

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

Re: Using IN operator with %IF %THEN %ELSE

kingCobra — Thu, 14 Sep 2017 11:55:52 GMT

RW9,

I made this simplified to facilitate understanding. The main issue is if &param has certain values, I want to execute certain steps. I have several of such %IF %THEN %ELSE block of codes.

Re: Using IN operator with %IF %THEN %ELSE

RW9 — Thu, 14 Sep 2017 12:04:19 GMT

Thats why I say it depends on the other code I can't see. There are two simple options:

1) Have two macros, and call one or the other based on the data:

%macro param_unit (param=,unit=);
...
%mend;

%macro param (param=);
...
%mend;

data want;
  set have;
  if param in ("A","B","C") then call execute(cats('%param_unit (param=',param,",unit=',unit,');'));
  else call execute(cats('%param (param=',param,');'));
run;

Or you could od it in the datastep within the macro, or you could do it in datastep with no macro. Probably several other options.

Edit; Just to add, the point of macro is to create generic reusable code, hardcoding data requirements in it reduces both these.

Re: Using IN operator with %IF %THEN %ELSE

Tom — Thu, 14 Sep 2017 12:13:57 GMT

Look at the MINDELIMITER system option or / MINDELIMITER= option on the %MACRO statement in the on-line documentation. You should find examples there.

I have used INDEXW() function to do this and find it works well and avoids worrying about MINDELIMITER.

%IF %sysfunc(indexw(A B C,&param)) %THEN %DO;
        .........................
%END;