topic How to mail SAS table in excel form? in SAS Programming

How to mail SAS table in excel form?

tarikbirinci1 — Mon, 24 Aug 2020 07:41:04 GMT

How to mail SAS table in excel form? How to mail errors?

andreas_lds — Mon, 24 Aug 2020 08:39:05 GMT

@tarikbirinci1 wrote:

How to mail SAS table in excel form?

By attaching the excel file to a mail. I am sure that you will find papers with code.

@tarikbirinci1 wrote:

How to mail errors?

What you mean exactly? Easiest way: use proc printto to save the log in am accessible directory, then just send the path to log.

tarikbirinci1 — Mon, 24 Aug 2020 08:47:48 GMT

I mean how can I do these with SAS code?

Kurt_Bremser — Mon, 24 Aug 2020 09:00:23 GMT

To create an Excel file, either use PROC EXPORT with DBMS=XLSX, or PROC PRINT with ODS EXCEL, or LIBNAME XLSX.

To send mail from SAS code, use FILENAME EMAIL.

You will find examples in the linked documentation.