Send ID's of dataset processed in an email

[etl_tool]

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

[AbhiD]

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