06-22-2015 03:16 AM
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!
06-22-2015 09:04 PM
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!
06-23-2015 08:55 AM
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.
06-22-2015 10:40 PM
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.
06-23-2015 01:13 AM
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.