Help for code to Insert table into email trigger by SAS

sagulolo · Posted 01-24-2019 03:46 AM

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.

ChrisNZ · Posted 01-24-2019 05:58 AM

Have you looked at the odsout object?

High-Performance SAS Coding - Third Edition

sagulolo · Posted 01-28-2019 01:35 AM

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.

Help for code to Insert table into email trigger by SAS

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

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

Help for code to Insert table into email trigger by SAS

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

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

The 2025 SAS Hackathon has begun!

SAS Training: Just a Click Away