Re: 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.