"Selected Server" option in SAS EG Program

[smm662002]

Hi,

When using Program in SAS EG 4.3 there is an option where the user can select the server (if more than one server available) to use: "Selected Server" (this option is on the Program toolbar between "Stop" and "Analyze Program" buttons.

Does anybody know if is possible to achieve the same results (to select the right server) but using code lines (maybe something similar to "libname" statement) instead of selecting the server manually?  

Thank you,

Madalin

[ChrisHemedinger · Accepted solution]

Madalin,

No, I'm afraid there isn't a way to do this from within your SAS program.

If you run the program via automation (such as in a VBScript), it can be done:

http://blogs.sas.com/content/sasdummy/2011/05/03/using-sas-enterprise-guide-to-run-programs-in-batch...

And you could write a script to "change" the server for a node in the project, and then re-save the project with the change.  Thus, you can automate the server switch, but not from within the user interface.

* However - even if you automate the server change for a program, if you have output data that is generated by the program and used "downstream", those data references will not be updated automatically.  So, subsequent tasks that use that data will not be updated and won't run correctly.

You can automate the overall "server resource" change throughout your project by using the MigrationWizard tool.  It's MigrationWizard.exe in your EG application directory, and the Help button provides access to quite a bit of detail.

Chris