topic Re: Performance in SAS Programming

Performance - email delivery time from UNIX

mathewse111 — Wed, 08 Dec 2021 14:40:22 GMT

I have program which analyses the data and create report. If we look at the execution of queries it takes only 35 minutes for SAS related queries and all. In the end the program send the report to outlook email from Unix SAS. Sometimes by the time we receive the email, it takes almost an hour and a half. Is there any known solutions ?

Re: Performance

Kurt_Bremser — Fri, 03 Dec 2021 20:23:41 GMT

How large is the report attachment?

Re: Performance

SASKiwi — Sat, 04 Dec 2021 03:20:47 GMT

So the entire SAS program runs in an elapsed time of 35 minutes, including the DATA step sending the email, but the email transmission takes 1.5 hours? This sounds like more of a question for your email system administrator.

Re: Performance

mathewse111 — Tue, 07 Dec 2021 14:32:25 GMT

When I review the logs, and add up the execution times , it adds up to 35 minutes, but the time difference between execution started and the email delivered is 1.5 hours.

Re: Performance

mathewse111 — Tue, 07 Dec 2021 14:33:12 GMT

Around 50 KB

Re: Performance

Kurt_Bremser — Tue, 07 Dec 2021 16:31:17 GMT

@mathewse111 wrote:
Around 50 KB

So this can't be the reason. Get in touch with your mail admins.

Re: Performance

mathewse111 — Wed, 08 Dec 2021 23:14:21 GMT

38-50 KB

Re: Performance

mathewse111 — Wed, 08 Dec 2021 23:14:21 GMT

When I review the log, execution time for sas statements is around 30/35 minutes. But the email is received after 2 hours or more. The sas program sends an email from a program running on a UNIX and the emails are sent to outlook running on Windows machines.

Re: Performance

Kurt_Bremser — Thu, 09 Dec 2021 06:13:08 GMT

How long does the step that sends the mail take? Is it a DATA step with FILE EMAIL, or ODS with an EMAIL file reference?