Send ID's of dataset processed in an email

etl_tool — Fri, 15 May 2015 13:26:12 GMT

Hi,

I'm working in SAS DI 4.2. After the job ends I am trying to send an ID column in a SAS Dataset via email. The issue here is I'm using publish email transformation which sends email as HTML. I need an email with ID's separated by Comma

For ex:

DATA IN SAS DATA SET WORK.TABLEA

ID DATE

1 05/15

2 05/15

I need to send email as

Job successfull and ID's processed are

@1,@2

Re: Send ID's of dataset processed in an email

AbhiD — Mon, 18 Jan 2016 09:57:45 GMT

Hi,

Can you put comma seperated values in a macro and use that as a parameter which can be mapped to the publish to email transform

and then this can used as a macro variable in the email body.

Rgds,

Abhi

topic Re: Send ID's of dataset processed in an email in SAS Programming

Send ID's of dataset processed in an email

Re: Send ID's of dataset processed in an email