Hi, I've requirements to send an email with xlsx. attachment along with the need to show the content from another temporary sas table in the email body.  Currently, the email attachment is working, can we add contents from another sas table to the email body as below?  Bold lines are to be added    Say example    DATA _NULL_;        FILE OUTBOX;     PUT %SYSFUNC(COMPBL("Hi )); PUT ; PUT %SYSFUNC(COMPBL("The following advertisers have a due to expire in the next 21 days:  &Client_Name..")); PUT ; "Adding list from the temp sas table  Firstname Familyname address " PUT %SYSFUNC(COMPBL("Please ask the clients to remove the tags from their website before this date.")); PUT ; PUT %SYSFUNC(COMPBL("Full list of Advertisers and their expiry date is attached.")); PUT ; PUT %SYSFUNC(COMPBL("Thanks")); run; FILENAME OUTBOX CLEAR; ... View more

Hi All, I'm working on a project that involves multiple SQL tables. We are running the program in scheduler using macros that run each table in the loop (i.e. 1 to n ). Sometimes, some of the SQL tables being drop by other user causing SAS to stop proceed further. Is there any way to bypass,  if the table does not exist then move on to pick the next one    ... View more