topic Re: An Email from sas in SAS Programming

An Email from sas

MG18 — Mon, 30 Jan 2017 10:34:30 GMT

Hi All,

I running below code from LSF(which run on Batchserver) :-

Code :-

FILENAME mail EMAIL

TO=(" mXX.bi@XXXmail.com " )

SUBJECT="DAILY ADVANCES ABOVE 1 CRORE." CONTENT_TYPE="text/html";

ODS LISTING CLOSE;

ODS HTML BODY=mail;

PROC PRINT DATA=DAILY_ADVANCES_ABV_1CRORE;

RUN;

ODS HTML CLOSE;

ODS LISTING;

But it fails saying that

ERROR: Email:the connection was refused

Can You please guide me how to resolve this error.

Re: An Email from sas

LinusH — Mon, 30 Jan 2017 12:40:24 GMT

Even if it's kinda old, I think this is still valid.

Also, be aware of userid being used (authorization problems...?)

http://support.sas.com/kb/18/363.html

Re: An Email from sas

ChrisHemedinger — Mon, 30 Jan 2017 13:00:16 GMT

Make sure you've set the EMAILHOST and EMAILSYS options, as well as any needed EMAILUSER/EMAILPW credentials (sometimes not needed).

Simple example:

options 
  emailhost='mailserver.company.com' 
  emailsys=smtp;

More complex (this is using GMail😞

options emailhost=
 (
   "smtp.gmail.com" 
   /* alternate: port=487 SSL */
   port=587 STARTTLS 
   auth=plain 
   /* your Gmail address */
   id="your_address@gmail.com"
   /* optional: encode PW with PROC PWENCODE */
   pw="your_password" 
 )
;

Re: An Email from sas

MG18 — Tue, 31 Jan 2017 07:51:40 GMT

hI Chris ,

Thank for ur reply.

Please tell me how to do this or which file should have this EMAIL host entry .

many Thanks in advance.......

Re: An Email from sas

ChrisHemedinger — Tue, 31 Jan 2017 14:11:23 GMT

You should be able to add the OPTIONS statement at the start of your SAS program. It might depend on your version of SAS -- I think in older versions the EMAILSYS and EMAILHOST options were "startup" options that need to go in a config file. But in recent versions, these can go in your program on an OPTIONS statement.

As far as the value to put in the EMAILHOST -- that information probably needs to come from your IT dept. It needs to be an SMTP server that any e-mail client can access. Depending on your setup, you might also need to supply credentials.