emailing an Attachment

Bridget53 — Tue, 07 May 2013 13:51:10 GMT

How would you email an attachment that the name is located in field in a SAS datasets and the name of the attachment will be difference from day to day? Below is the code I try to use but I get an error message.

filename mymail email;

data _null_;

set logfile.logname;

file mymail

to=('bridget_nelson@hesc.ny.gov')

from='SASAdmin@hesc.ny.gov'

replyto= ('bridget_nelson@hesc.ny.gov>')

subject='Testing'

attach = "D:\Scheduled_Tasks\GnS\" || LogfileName;

strBody = "Testing of getting log file name from dataset.";

put strBody ;

run;

Here is the error message:

filename mymail email;

data _null_;

set logfile.logname;

file mymail

to=('bridget_nelson@hesc.ny.gov')

from='SASAdmin@hesc.ny.gov'

replyto= ('bridget_nelson@hesc.ny.gov>')

subject='Testing'

attach = "D:\Scheduled_Tasks\GnS\" || LogfileName;

------------------------- -----------

24 23

ERROR 24-2: Invalid value for the ATTACH option.

ERROR 23-2: Invalid option name LOGFILENAME.

strBody = "Testing of getting log file name from dataset.";

put strBody ;

run;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.03 seconds

cpu time 0.03 seconds

Re: emailing an Attachment

Haikuo — Tue, 07 May 2013 14:38:05 GMT

An easy fix on your current code is to use a Macro variable carrying the file name. Try this:

data _null_;

set logfile.logname;

call symputx('LogfileName', LogfileName);

/*stop;*/

run;

data _null_;

file mymail

to=('bridget_nelson@hesc.ny.gov')

from='SASAdmin@hesc.ny.gov'

replyto= ('bridget_nelson@hesc.ny.gov>')

subject='Testing'

attach = "D:\Scheduled_Tasks\GnS\&LogfileName";

strBody = "Testing of getting log file name from dataset.";

put strBody ;

run;

Haikuo

Re: emailing an Attachment

Bridget53 — Tue, 07 May 2013 14:49:10 GMT

Thank you.

topic Re: emailing an Attachment in SAS Programming

emailing an Attachment

Re: emailing an Attachment

Re: emailing an Attachment