topic Re: How to run a SAS program on a specific application server in SAS Programming

How to run a SAS program on a specific application server

RupaJ — Mon, 03 Dec 2018 20:52:26 GMT

Hello,

How do I run the SAS code on a specific application server on linux command line? We have 2 app servers - SASAPP and SASAPP2 with SASAPP2 having more memory allocated. So I would like to run on SASAPP2 to make sure all the memory is allocated to the code to avoid any failures.

On SASEG, I just choose the option from "selected server". However not sure how I can do that on linux command line.

Also any command line tips on running long running SAS programs on linux? Any examples would be very helpful.

Thanks!

Re: How to run a SAS program on a specific application server

r_behata — Mon, 03 Dec 2018 22:36:49 GMT

Multiple Instances of the SASApp can be running on the same server or can be distributed across different servers.

The SAS Metadata server makes these details seamless when you switch from SASAPP instance from the other from any of the clients.

However, you need to know the server name mapped to your second logical instance(SASAPP2) to manually run the code directly on that server.

Re: How to run a SAS program on a specific application server

SASKiwi — Mon, 03 Dec 2018 23:52:04 GMT

Why do you need to run SAS jobs from a linux command line? It is a whole lot easier doing this from SAS Management Console Schedule Manager.

Re: How to run a SAS program on a specific application server

SuryaKiran — Tue, 04 Dec 2018 00:04:47 GMT

Hi Rupa,

You may have to use GRIDAPPSERVE option in SASGSUB.

Check this out --http://support.sas.com/documentation/cdl/en/gridref/67371/HTML/default/viewer.htm#p05eo0im8mix5qn1bz77trdvzd2s.htm

Re: How to run a SAS program on a specific application server

ChrisNZ — Tue, 04 Dec 2018 01:33:30 GMT

Are you talking about sending to a different machine or executing locally?

Do you want to just call the sas executable or do you want to go through the SAS Metadata server?

It's the latter case it seems since you want to use SASAPP2. So you need to talk to the SAS Metadata server. This can be done via different methods, for example using CORBA or Java. The documentation for the Open Metadata Interface is here.

Re: How to run a SAS program on a specific application server

RupaJ — Tue, 04 Dec 2018 02:19:40 GMT

@ChrisNZ - I just want to execute locally on the compute server.

@SASKiwi - The reason I want to run on linux command line is due to the fact that we have SSO enabled and that expires the SASEG session every 10 hours. This is causing our long running SAS programs to fail, so I am looking to run from command line where I can auto renew/extend the kerberos tickets.

@SuryaKiran - Thanks Surya. This seems to be SAS grid options and we don't have that.

Just to provide more details, we have 2 servers - meta and compute. Compute server has 2 app servers - sasapp and sasapp2 and I would like to run the sas code on sasapp2 context form command line. Something like

/opt/sas/sashome/SASFoundation/9.4/sas sascode.sas -log sascode.log "-option" sasapp2.

I also see the options -memsize /-sortsize. Should I just mention those and run the code?

Re: How to run a SAS program on a specific application server

SASKiwi — Tue, 04 Dec 2018 02:44:04 GMT

@RupaJ - I'm suggesting SAS Management Console, not EG. A batch job started by SMC will not be affected by any timeout limits on the SMC to SAS server connection - you can close SMC and the batch jobs continue totally independently.

Re: How to run a SAS program on a specific application server

RupaJ — Tue, 04 Dec 2018 17:38:14 GMT

Thanks @SASKiwi. I started looking at that. I was able to schedule the job, however when I run it , nothing happens. I am still checking where the logs are getting generated. Looks like I need to install the flow manager to check the status of the jobs.

Re: How to run a SAS program on a specific application server

SASKiwi — Tue, 04 Dec 2018 19:02:54 GMT

@RupaJ For SMC you can assign the directory for the batch job logs on the Properties of the Server Manager - SASApp - SAS DATA Step Batch Server.

Re: How to run a SAS program on a specific application server

RupaJ — Wed, 05 Dec 2018 20:59:42 GMT

Thanks @SASKiwi!! That's exactly what I was looking for.

Re: How to run a SAS program on a specific application server

SASKiwi — Wed, 05 Dec 2018 21:34:40 GMT

Cool @RupaJ - I must admit finding where to configure stuff in SMC is sometimes not obvious...

Re: How to run a SAS program on a specific application server

RupaJ — Fri, 07 Dec 2018 01:34:26 GMT

@SASKiwi - Couple more questions, if you could clarify?

Do I need the flow manager to check the status of the jobs? Is there a way to check the status of the jobs from SASMC?

Also I read we can email the status of the job. Any direction on how to configure that?

Thanks!

Re: How to run a SAS program on a specific application server

SASKiwi — Fri, 07 Dec 2018 02:14:29 GMT

@RupaJ - what scheduler are you using? Platform Process Manager or Operating System Services?

Re: How to run a SAS program on a specific application server

RupaJ — Fri, 07 Dec 2018 11:48:18 GMT

@SASKiwi - Operating System Services.

Re: How to run a SAS program on a specific application server

RupaJ — Fri, 07 Dec 2018 12:09:55 GMT

@all - And just to circle back to my original question. I used the following command on linux

/opt/sas/SASHome/SASFoundation/9.4/sas run_queries.sas -work /SAS_Work/WS2/SASWork -memsize 171798691840 -sortsize 17179869184 -log /SAS_Testing/tests.log

It errors out within minutes. However when I execute the code in SASEG (Enterprise guide), it runs fine with no issues. I guess I am missing to add some necessary options ?? Any idea.

Attached is the complete log.

Re: How to run a SAS program on a specific application server

RupaJ — Fri, 07 Dec 2018 14:30:34 GMT

Just to add, @SASKiwi - I ran the same code from SASMC too and it error ed out.

Re: How to run a SAS program on a specific application server

SASKiwi — Fri, 07 Dec 2018 21:24:40 GMT

These are your log errors:

ERROR: File PCORDATA.vwLAB_RESULT_CM_v31.DATA does not exist.
ERROR: File PCORDATA.vwLAB_RESULT_CM_v4.DATA does not exist.

If you fix these your job might work. Also it appears you don't include your source code in your log. If you do that normally then I would advise against it. Including the source code in your logs (SAS option SOURCE) is best practice in my view.