topic combine two codes in SAS Enterprise Guide

combine two codes

hk2013 — Wed, 20 Jun 2018 23:30:30 GMT

I have this code that send out email with text in the email from a email address found in the data pulled (code 1)and i have another code that makes a excel file for each email/person and email that(code 2) what I want to do is match the email/names in both codes and attach the excel file from code 2 to code 1 email and get rid of the email in code 2 all together.

Re: combine two codes

Kurt_Bremser — Wed, 29 Nov 2017 07:43:47 GMT

Run the excel export code before you send email "one", and use the attach= option there in the filename email.

Re: combine two codes

hk2013 — Wed, 29 Nov 2017 15:44:09 GMT

how will the email (code 1) know to attach the excel file that matches the same name?

Re: combine two codes

hk2013 — Tue, 26 Dec 2017 23:58:39 GMT

is there code that can tell the email to match the email address or names so that it only gets data and excel file for a specific person and sents that out.

Re: combine two codes

SASKiwi — Sat, 30 Dec 2017 21:51:07 GMT

To dynamically email different recipients with different attachments you will need to use PUT statement email directives. This link to the documentation explains directives:

http://support.sas.com/documentation/cdl/en/lestmtsref/63323/HTML/default/viewer.htm#n0ig2krarrz6vtn1aw9zzvtez4qo.htm

Re: combine two codes

Kurt_Bremser — Tue, 02 Jan 2018 10:28:46 GMT

@hk2013 wrote:

is there code that can tell the email to match the email address or names so that it only gets data and excel file for a specific person and sents that out.

First, set up a list of recipients in a dataset.

Then, wrap your code(s) in macro definitions where the recipient is accepted as a macro parameter.

Now you can use call execute() to call your macro(s) from the recipients dataset.