%if condition

[Rajeshganta]

%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

[Kurt_Bremser]

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.

[Amir]

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.

[Tom]

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;

[Rajeshganta]

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

[Kurt_Bremser]

You expand the %IF with %ELSE:

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

[Amir]

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.