topic Re: Scheduling using SAS EG, or any other scheduling methods? in SAS Enterprise Guide

Scheduling using SAS EG, or any other scheduling methods?

t30 — Tue, 07 Aug 2018 08:50:47 GMT

I'm looking at ways to automate some weekly SAS scripts. Currently it needs human intervention on a weekly basis which is kinda redundant and boring.

One of the methods I found require the use of Connection if I were to use SAS EG as below

However when I open my SAS EG, such option is not available as below

Would it be possible to enable this? If not probably it's not part of the license.

What other options do I have? I also looked into 'Task Scheduler' but this requires admin right, so it's not an option.

Thanks

Re: Scheduling using SAS EG, or any other scheduling methods?

Kurt_Bremser — Tue, 07 Aug 2018 09:27:03 GMT

The connection profiles have nothing to do with scheduling, they just define your access to a metadata server.

Since you work locally, you have to use the Windows scheduler.

Re: Scheduling using SAS EG, or any other scheduling methods?

t30 — Tue, 07 Aug 2018 09:37:25 GMT

Most of the tables are not locally hosted though, so yeah, I think I still need that connection profile. Is there a reason why my version has no connection profile available?

Re: Scheduling using SAS EG, or any other scheduling methods?

SASKiwi — Tue, 07 Aug 2018 21:01:01 GMT

Connection profiles are only relevant if you are working with a remote SAS server. EG will also work with local SAS on your PC in which case no profile is required.

This SAS note explains how to schedule in EG: http://support.sas.com/kb/56/648.html

You may also want to consider using SAS server-based scheduling which is available in SAS Management Console. This is the most reliable way to do it.

Re: Scheduling using SAS EG, or any other scheduling methods?

t30 — Wed, 08 Aug 2018 01:34:45 GMT

Yes, I'm working with both local SAS and remote SAS server, back and forth. Typically because the SAS server has access to the data lake.

Problem is, even if the connection is relevant, I can't find the option there.

Re: Scheduling using SAS EG, or any other scheduling methods?

Kurt_Bremser — Wed, 08 Aug 2018 04:28:06 GMT

If you have a SAS server, do all the scheduling there. Save all your code to .sas files and schedule those, using the Data Step Batch Server.

Re: Scheduling using SAS EG, or any other scheduling methods?

SASKiwi — Wed, 08 Aug 2018 04:40:35 GMT

The scheduling option? You can find it on the EG File menu ==> Schedule Project.