emailing an Attachment

[Bridget53]

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

s

[Haikuo]

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

[Bridget53]

Thank you.