topic macro comparison operator in SAS Programming

macro comparison operator

Bill — Tue, 27 May 2008 19:30:00 GMT

The first macro pgm does not work in SAS 9.1.3. An alternative is to use the second one, however, I'd rather not repeat the "proc print data=test;run;" section since it's actually very long in my pgm. Perhaps I'm having a brain cramp, but I haven't been able to come up with an alternative. Can someone help? (&runflg comes in from another part of the pgm). Thanks, Bill

%macro report; %*First;

%if &runflg in 1,5 %then %do;
proc print
data=test;
run;
%end;

%mend report;
%report;

%macro report;%*Second;

%if &runflg = 1 %then %do;
proc print data=test;
run;
%end;

%else %if &runflg = 5 %then %do;
proc print data=test;
run;
%end;

%mend report;
%report; changed %runflg to &runflg

Message was edited by: Bill

Re: macro comparison operator

Peter_C — Tue, 27 May 2008 20:57:35 GMT

of course the OR logic would provide a substitute for IN
However, IN should be working..... if you set system option different from the default NOmInOperator 😉
Try
%put abc = %eval( 1 in 1 2 3 ) ;
%put def = %eval( 1 in 1,2, 3 ) ;

If you want to use a comma separator for the IN list, then set option mInDeliminator

Good Luck
PeterC

Re: macro comparison operator

deleted_user — Thu, 29 May 2008 08:47:12 GMT

sorry,
that last posting was using options from SAS9.2
which introduces the IN operator to the SAS Macro language.

For SAS 9.1.3 you need to create your own, or use OR, like [pre]
%if &runflg = 1 OR &runflg =5 %then %do;
[/pre]
Good Luck

PeterC

Re: macro comparison operator

Bill — Thu, 29 May 2008 16:37:58 GMT

Thank you Peter.

How odd (to me at least) that it's not %OR.

wd

Re: macro comparison operator

deleted_user — Wed, 08 Oct 2008 09:56:10 GMT

Hi,
i tried to use IN but it does not work (lvl 9.1.3) and reading you messages it works from 9.2 explains a lot
BUT read the sas help: http://support.sas.com/onlinedoc/913/getDoc/nl/mcrolref.hlp/a002475219.htm

Here it says it should work from level 9 !!!

GreetZ,
Herman

Re: macro comparison operator

LinusH — Wed, 08 Oct 2008 10:30:47 GMT

Here's the explanation for that:

http://support.sas.com/kb/11/945.html

/Linus