DATA Step, Macro, Functions and more

Send ID's of dataset processed in an email

Reply
Contributor
Posts: 21

Send ID's of dataset processed in an email

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

Contributor
Posts: 26

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

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

Ask a Question
Discussion stats
  • 1 reply
  • 138 views
  • 0 likes
  • 2 in conversation