Desktop productivity for business analysts and programmers

Forcing all sas queries to execute remotely

Reply
New Contributor
Posts: 4

Forcing all sas queries to execute remotely

Hi,

I'm trying to setup Enterprise Guide so all code will be executed remotely by using the Custom Code in the options to wrap everything with rsubmit.

However, I'm running into problems with signing on.

I am using Enterprise Guide on a client pc, and am trying to submit to SAS on an AIX server XXXXXXXX port 8561. So I have used the following in my custom code but with no success:

signon XXXXXXXX.8561;

rsubmit;

*************************************

%let serv = XXXXXXXX 8561;

signon serv;

rsubmit;

*************************************

%let serv = XXXXXXXX 8561;

options comamid=TCP remote=serv;

rsubmit;

*************************************

However, I keep getting repeated errors, stating either 'a tcp link needs to be established' or 'a link must be established by executing the SIGNON command'.

Going round in circles on that SAS website with different options and recommendations, but nothing has worked. Any suggestions?

Trusted Advisor
Posts: 2,114

Forcing all sas queries to execute remotely

Why don't you just choose the SAS Server that you want to use from within EGuide?   That seems a much more direct approach.

New Contributor
Posts: 4

Forcing all sas queries to execute remotely

I don't want to submit the query locally on my client machine, I want to submit it remotely to the server.

When i select the SAS server within EG and submit, it performs the query in place. I want to force all code submitted to remote submit to a server.

Trusted Advisor
Posts: 2,114

Forcing all sas queries to execute remotely

Sounds like you might be using the wrong profile.  You can check (and create) profiles in tools --> options --> administration --> connection profiles and set up a default (remote) server there.

Super User
Super User
Posts: 6,845

Forcing all sas queries to execute remotely

EG always submits code to a Server.  Are you saying you do not want to use your local machine as the server?  Can't you just connect to a different server?

New Contributor
Posts: 4

Forcing all sas queries to execute remotely

I am under the impression that while code or a query runs in EG, the majority of the processing runs in the foreground. A job needs to explicitly call rsubmit to submit it as a batch job

to a server and execute there, freeing up the eg session.

If this is not the case then, it looks like i don't have a problem. N.B. I am an infrastructure admin concerned with using EG to replace a similar remote submite function.

Super User
Posts: 3,235

Forcing all sas queries to execute remotely

Just to reinforce Tom's comment, EG is a thin-client interface to SAS, so all code submitted by EG runs on a SAS server. That server might be the same PC as EG if it has a complete SAS install. If it hasn't then there is no option but to run the code on a remote server, in your case AIX Unix server.

When you start EG it usually automatically signs on to the remote server(s) so signon and rsubmit statements become redundant.

New Contributor
Posts: 4

Forcing all sas queries to execute remotely

Tom & SASKiwi, thank you.

I am a relative newcomer to SAS and was getting a bit muddled when trying to convert functionality from existing applications to other applications.

Super Contributor
Posts: 349

Forcing all sas queries to execute remotely

Hi ,

Try this...Hope this helps..

signon outtsk2 sascmd="C:\Program Files\SAS\SASFoundation\9.2\sas.exe -nosyntaxcheck";

rsubmit outtsk2 wait=no;

libname tt 'F:\SASALM';

data tt.want;

input name $ no;

cards;

test 12

want 23

ravi 44

;

run;

endrsubmit;

signoff outtsk2;

Thanks,

Shiva

Regular Contributor
Posts: 233

Forcing all sas queries to execute remotely

  • You can create a profile in SAS EG by clicking on "No profile selected" on the bottom right hand side corner of the tool.
  • A window pops up. Click on Add.
  • Another window pops up and will ask you for details like Name, Description,  Machine, port, User, Password and authentication domain.
  • Enter all those details and click on Save.
  • Click on Set active.

This connects you to the server. Once connected successfully. Run the code begininning with the line RSUBMIT <SERVERNAME>; and end the code with ENDRSUBMIT;

Ask a Question
Discussion stats
  • 9 replies
  • 306 views
  • 2 likes
  • 6 in conversation