topic Re: Conditional sending of email via sas in New SAS User

Conditional sending of email via sas

SIgnificatif — Tue, 27 Aug 2019 09:46:37 GMT

Hi, I would like to ask you how to conditionally send an email from sas ?

%let variable1 ='go';

 if variable1 = 'go' then do;


FILENAME mail
EMAIL TO=(&emails)
etc ....
end;

Thank you.

Re: Conditional sending of email via sas

Jagadishkatam — Tue, 27 Aug 2019 09:51:15 GMT

You can something like below, consider that the code is within the macro sample, this is an untested code

%macro sample;

%global variable1;

%let variable1=go;

%if &variable1=go %then %do;
filename mail email to='xxxxx@xxxx.com';
data _null_;
file mail;
put 'Hi';
run;
%end;

%mend sample;

%sample

Re: Conditional sending of email via sas

Kurt_Bremser — Tue, 27 Aug 2019 11:20:37 GMT

Starting with SAS 9.4M5 (I think), %if can be used in open code (no macro definition necessary):

%let variable1=go;

%if &variable1=go %then %do;


FILENAME mail
EMAIL TO=(&emails)
etc ....

%end;

Note that macro variables very rarely need quotes, quote are usually unnecessary and cause problems.

Re: Conditional sending of email via sas

Tom — Tue, 27 Aug 2019 14:20:48 GMT

Is VARIABLE a macro variable, as it it appears in your first statement, or an actual variable in a SAS dataset, as it appears in your second statement? If the later does the data have just one observation? If not what if some of the observations have values of go and other observations have values that are something else? Do you still want to send the email?

Re: Conditional sending of email via sas

SIgnificatif — Tue, 27 Aug 2019 14:23:42 GMT

it's a macro variable
1 I need to use a condition to check the value ,
2 else send another email. ( i found that there is no possibility to do an elseif if in macro variable mode) , limiting this to only 2 conditions...

Re: Conditional sending of email via sas

Tom — Tue, 27 Aug 2019 14:37:10 GMT

Not sure what an elseif is, but there is definitely a macro %ELSE statement.

%if &variable=go %then %do;
....
%end;
%else %if &variable=stop %then %do;
....
%end;
%else %do;
....
%end;

Re: Conditional sending of email via sas

Kurt_Bremser — Wed, 28 Aug 2019 08:01:35 GMT

@SIgnificatif wrote:
it's a macro variable
1 I need to use a condition to check the value ,
2 else send another email. ( i found that there is no possibility to do an elseif if in macro variable mode) , limiting this to only 2 conditions...

You can use %else %if, as @Tom already showed, but this needs a macro definition. To implement the same logic in open code, you need to code the else-path with a separate %if:

%if &variable1 = go
%then %do;

%end;
%if &variable1 ne go
%then %do;

%end;