topic Re: %if condition in SAS Enterprise Guide

%if condition

Rajeshganta — Fri, 09 Jul 2021 06:28:33 GMT

%let &num=101;
%if %sysfunc(input(&num., Bestx12.)) GE 100 %then %let &email="raj@gma.com";
Mailer code
To=(&email.)
I am using this script but getting the error as %if statement in open code
Please help me solve the issue

Re: %if condition

Kurt_Bremser — Fri, 09 Jul 2021 06:44:34 GMT

If you use %IF in open code (outside a macro), it has to have %DO-%END blocks for the %THEN and %ELSE branches.

Also note that the "open code %IF" is a fairly recent addition to the SAS system, so you need to have at least 9.4M5, IIRC.

And also note that you cannot use INPUT in %SYSFUNC, you need to use INPUTN or INPUTC.

Re: %if condition

Amir — Fri, 09 Jul 2021 09:22:28 GMT

Hi @Rajeshganta,

Once you have fixed the issue causing the error, you will probably also want to look at the %let statements, as you don't need an ampersand ("&") before the variable you are assigning, as you have done for num and email, you only need the ampersand in front when you want to use the value that the variable is holding.

Kind regards,

Amir.

Re: %if condition

Tom — Fri, 09 Jul 2021 12:24:50 GMT

In open code you need %DO/%END blocks.

You don't need the INPUT() code. The %EVAL() macro function that SAS uses for %IF conditions knows how to perform integer arithmetic.

%let num=101;
%if &num GE 100 %then %do;
  %let email="raj@gma.com";
%end;

If you need to perform floating point calculations or use date literals then use %SYSEVALF().

%if %sysevalf(&num GE 100) %then %do;

Re: %if condition

Rajeshganta — Fri, 09 Jul 2021 14:07:05 GMT

Thank you so much tom, i am able to use the code shared but i need to give else also in this condition that should solve my query for triggering an email only when numver exceed and else it should not execute

Re: %if condition

Kurt_Bremser — Sat, 10 Jul 2021 05:32:11 GMT

You expand the %IF with %ELSE:

%if <condition>
%then %do;
....
%end;
%else %do;
....
%end;

Re: %if condition

Amir — Sat, 10 Jul 2021 21:39:00 GMT

Hi @Rajeshganta,

To find out more about the special requirements / limitations of using %if in open code then you can read this SAS blog post.

Thanks & kind regards,

Amir.