SAS email issue when using if then else

Deepti44 — Wed, 26 Jul 2017 15:31:51 GMT

Hi,

I'm trying to send an email with output and email content to valid userid see below :

when i'm using set statement , my contents in the emial is not getting displayed i from the "else" part , any idea where i'm doing worng !

filename mailbox email;
data _null_;
set my_log1;
if &sysuserid='uvm472' then do ;
file mailbox to="Deepti@yahoo.com" subject='deepti test';
put _all_;
end;
else do;
file mailbox to="Deepti@yahoo.com" subject='not deepti test';
put " pbdv report is successfull";
end;

run;

Re: SAS email issue when using if then else

RickAster — Wed, 26 Jul 2017 18:18:09 GMT

I see three things I would encourage you to look at.

Comparing a macro variable to a character constant in a data step IF statement is probably not what you want. I don't know what the value of &SYSUSERID would be, but supposing it is something like USER100, this would be a word that SAS would treat as a variable name. Then the results of this would depend on whether there is a variable called USER100 in the data set MYLOG1.
When a data step contains multiple FILE statements with the same fileref (MAILBOX in this example) containing options, I believe the data step consolidates those options the same as if they all appeared in one statement. This means you can't use IF-THEN statements to control FILE statement options.
To use a data step to control email options or to send more than one message from one data step it is usually necessary to use email directives. For example, you might write
```
put '!em_to! ' to_email;
```
to set the recipient based on the value of a data step variable. For the details of the directives, see "PUT Statement Email Directives" at http://support.sas.com/documentation/cdl/en/lestmtsref/69738/HTML/default/viewer.htm#n0ig2krarrz6vtn1aw9zzvtez4qo.htm.

Sorry for the short reply. I hope some of this helps.

topic SAS email issue when using if then else in SAS Programming

SAS email issue when using if then else

Re: SAS email issue when using if then else