topic Re: About email from SAS in SAS Programming

About email from SAS

devnand — Thu, 10 Nov 2016 23:09:31 GMT

I am not sure what is wrong with the code. I want to check whether the file exist in the directory. and if it exists then just write it to the log, else send an email.

It is sending an email to be whether the file is present or not. If the file is present, it is sending an email without the body part. If not present, it is going through the loop. What is that I am missing here?

filename mailbox email 'sashelp@outlook.com" subject: missing file

data _null_;

Check= %sysfunc(fileexist(C:temp/test.csv));

if Check=0 then do;

file mailbox;

PUT "Hello,";

PUT "Please check the directory. The file is missing.";

PUT "Thanks.";

end;

else if Check=1 then do;

put "Note: File Exists: " ;

end;

Run;

Thanks

Dev Lama

Re: About email from SAS

Reeza — Thu, 10 Nov 2016 23:13:19 GMT

Move the file statement out of the IF condition? Though I didn't think it was a conditional statement (ie executed regardless of where it is). Maybe I don't understand your problem though.

Re: About email from SAS

ballardw — Thu, 10 Nov 2016 23:30:30 GMT

You almost never need %sysfunc inside a data step. The purpose of %sysfunc is to call a data step Function in macro code outside of a data step.

Check= fileexist(C:temp/test.csv);

Re: About email from SAS

Jagadishkatam — Fri, 11 Nov 2016 02:28:56 GMT

Hi Dev,

your code seems fine, but few changes could help you get the expected email.

please try the below code which I modified taking your code.

filename mailbox email to='sashelp@outlook.com' subject= 'missing file';

data _null_;

Check=fileexist('C:temp/test.csv');

if Check=0 then do;

file mailbox;

PUT "Hello,";

PUT "Please check the directory. The file is missing.";

PUT "Thanks.";

end;

else if Check=1 then do;

put "Note: File Exists: " ;

end;

Run;

Re: About email from SAS

devnand — Fri, 11 Nov 2016 03:02:25 GMT

The logic that I am trying to implement is that when the file exist in that folder, do not send the email, but if the file does not exist please send the email.

Even when the file is present, the email is getting triggered.

Thanks

Dev Lama