Desktop productivity for business analysts and programmers

Scheduling using SAS EG, or any other scheduling methods?

Reply
Contributor t30
Contributor
Posts: 41

Scheduling using SAS EG, or any other scheduling methods?

Hi 

 

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

egc.PNG

 

 

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

sasegm.png

 

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

Super User
Posts: 10,601

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

[ Edited ]

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor t30
Contributor
Posts: 41

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

Posted in reply to KurtBremser
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?
Super User
Posts: 4,030

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

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.

Contributor t30
Contributor
Posts: 41

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

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.
Super User
Posts: 10,601

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 4,030

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

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

Ask a Question
Discussion stats
  • 6 replies
  • 85 views
  • 0 likes
  • 3 in conversation