Advanced SAS | PROC-X.com

Sending Email from within SAS and other options…

FILENAME Statement EMAIL (SMTP) Access Method allows you to send electronic mail programmatically from SAS using the SMTP (Simple Mail Transfer Protocol) e-mail interface available at your site.

But before you process the email code below check the values for the system options using Proc options for EMAILAUTHPROTOCOL, EMAILHOST, EMAILPORT, EMAILID, EMAILPW for your site…They have to have appropriate values for your code to work.

Read more about them @ System Options That Control SMTP E-Mail.

proc options group=email; run;

The Log generated…

59 proc options group=email; run;

SAS (r) Proprietary Software Release 9.1 TS1M3

EMAILAUTHPROTOCOL=LOGIN

Identifies the SMTP e-mail authentication protocol

EMAILHOST=xxx.xx.xx.xxx

SMTP server host for email access method

EMAILID=xxxxxx From E-mail address, log in id, or profile for use with underlying e-mail

system

EMAILPORT=25 Port number for SMTP server for email access method

EMAILPW=xxxxxxxx Used by the E-mail Access Method and Send menu item to set the email session

login password for the underlying e-mail system

EMAILDLG=native Used by Send menu item to set the email dialog interface.

EMAILSYS=smtp Used by E-mail Access Method and Send menu item to set the interface type with

underlying e-mail system.

Try the following email example for sending an email using SAS data step…replace emails and the attachments as you wish…This example has the most common options that you might use….Please look at the SAS examples in the References (5-7) below for some more advanced methods….

filenameoutbox email “sastechiesblog@gmail.com”;

data_null_;

fileoutbox

to=(“sastechiesblog@gmail.com”“info@sastechies.com”)

/* Overrides value in filename statement */

cc=(“info@sastechies.com”“someone@mail.com”)

subject=“My SAS Output”

attach=(“C:sasresults.out”“C:sascode.sas”)

;

put‘Folks,’;

put‘Attached is my output from the SAS’;

put‘It worked great!’;

run;

Here is another way of sending emails using SAS X command in a Unix Environment that has the mailx utility…Sometimes it might just better to use the native operating system utilities rather than using SAS Filename Email Statement…

Here’s a macro that does that for you…

%macroSendEmail;

/*Write the contents to a file */

data _null_;

file “&emailfile”lrecl=256;

%emailbody;

run;

/* %put to=&to cc=&cc subject=&subj attach=”&attach”; */

/*use the X command and invoke the Unix mailx command */

X “(cat &emailfile;) | mailx -s “”&subj”” &to –c &cc”;

X ” if [[ $? -ne 0 ]] then echo `date`” “Failed to send email to &to” “else rm ~/&emailfile fi”;

%mendSendEmail;

%letsubj=Hey SASTechies;

%letto=sastechiesblog@gmail.com;

%letattach=;

%letcc=;

%letemailfile=~/email.dat; /* path to the temporary file at home directory (ie. ~) */

%macroemailbody;

PUT “This is a test message from SASTechies”;

PUT “This test mail has been generated from SAS Data Step using Native Unix Mail command”;

%mendemailbody;

%SendEmail;

A brief explanation here…

Enter your email/attachment/subject in the macro variables…the &emailfile is a temporary file that SAS writes to compile the email body…This is later deleted if SAS was successful in sending the email…

X “(cat &emailfile;) | mailx -s “”&subj”” &to –c &cc”;

The unix command cat &emailfile writes the body for the mailx unix command that takes –s option for subject followed by the to and cc options.

Check the unix man page screenshot below for more options…

Other References

1. http://support.sas.com/techsup/technote/ts605.html
2. http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a002058232.htm
3. System Options That Control SMTP E-Mail
4. Statements That Control SMTP E-mail
5. Using Conditional Logic in a DATA Step
6. Sending Procedure Output in E-mail
7. Creating and E-mailing an Image

Tag: Advanced SAS

SAS Online training Youtube Channel

Sending Email from within SAS and other options…

The top 10 errors, notes and warnings that prompt DATA step programmers to call SAS Technical Support

Creating a search engine in SAS

Making SAS Interactive (Part 2): Using %window and %display

Reading a table from a website into a SAS dataset

SAS Macro to put SAS data into Multiple Excel Work sheets

Indexing in SAS.. In a baby’s language