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')
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')
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
s
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')
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
Thank you.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.