topic Help for code to Insert table into email trigger by SAS in SAS Programming

Help for code to Insert table into email trigger by SAS

sagulolo — Thu, 24 Jan 2019 08:46:53 GMT

Hi SAS communities,

I actually new to SAS code for trigger email, i just wanted to send email to my user report available to retrieve from share folder after my EG job completed, attached my code and screenshot:-

filename mymail 

email 'myemail@yahoo.com.my'  
subject='report xxxx';


data _null_;
   file mymail;
   
   put 'Dear all,';
   put ;
   put 'All reports available in shared folder.';

   put '<html><body><table>';
   PUT '<tr><td>Shared Folder</td><td>Report Name</td>';
   PUT '<tr><td> test </td><td> test2 </td>';
   PUT '</table></body></html>';

   put ;
   put 'Thanks & Regards,';

run;

Results:

Expected:

**link A actually is hyperlink to the share folder

Please advice and guide me how to get the expected table, thanks you in advance.

Re: Help for code to Insert table into email trigger by SAS

ChrisNZ — Thu, 24 Jan 2019 10:58:23 GMT

Have you looked at the odsout object?

Re: Help for code to Insert table into email trigger by SAS

sagulolo — Mon, 28 Jan 2019 06:35:47 GMT

Hi ChrisNZ,

My apologies for late reply and thank for your guidance.

Let me go through the article and test it first before i come back to you.

Thank you so much for your time.