topic Re: Task Schedule - SAS EG in SAS Enterprise Guide

Task Schedule - SAS EG

rush_milo — Mon, 22 Jun 2015 07:16:02 GMT

Hi,

I have a question on scheduling in SAS EG. I'm given a task to schedule a program.

My question is, instead of schedulling the whole program, is it possible to schedule the output as well?

Say, the program has been run and produces an output, e.g Dataset_A and I want to export Dataset_A in Excel format to a particular folder/location in C: drive, how can I do that in SAS EG? Reason being is I see the schedule options are very limited and high level. From what I see, it runs the whole thing instead of assigning particular tasks.

Appreciate anyone's assistance in this because I just started to use SAS 4 months ago and I'm practically a trainee. Thank you!

Re: Task Schedule - SAS EG

rush_milo — Tue, 23 Jun 2015 01:04:15 GMT

Hi,

I think I've found the answer to that. I can use Proc Export I believe.

Now, my other question is, it is possible to write a code to change the server? Because at my workplace, some codes have to be run under a different server.

Hope my question makes sense. Thank you!

Re: Task Schedule - SAS EG

SASKiwi — Tue, 23 Jun 2015 02:40:46 GMT

So is it definitely a SAS program you need to schedule and not an EG project? Do you use EG with a local SAS server (on your PC) or a remote server?

The difficulty of exporting to your C: drive from EG if you use a remote server is that SAS programs run remotely and hence cannot link to your C: drive.

If you use a local SAS server then there should be no problem - you can use the EXPORT procedure or the ODS EXCELXP tagset to write an Excel spreadsheet to your C: drive.

Re: Task Schedule - SAS EG

Kurt_Bremser — Tue, 23 Jun 2015 05:13:07 GMT

The most important thing to know is the layout of your SAS installation, epecially where the workspace server is located (local, remote, if remote, which operating system).

And what environment for scheduling is available and must be used according to organization policies.

Re: Task Schedule - SAS EG

Kurt_Bremser — Tue, 23 Jun 2015 12:55:06 GMT

Could you be more specific?

You see, code runs ON a server, so it can't magically hop from one server to another. That would be equivalent to your Windows desktop suddenly appearing on a computer at the other end of the office.