DATA Step, Macro, Functions and more

emailing an Attachment

Reply
Occasional Contributor
Posts: 7

emailing an Attachment

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

Respected Advisor
Posts: 3,124

Re: emailing an Attachment

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

Occasional Contributor
Posts: 7

Re: emailing an Attachment

Thank you.

Ask a Question
Discussion stats
  • 2 replies
  • 412 views
  • 0 likes
  • 2 in conversation