topic Re: Customize SAS invocation command in Administration and Deployment

Customize SAS invocation command

ashrivastava — Mon, 13 Jan 2020 20:09:45 GMT

Hi,

I am relatively new to SAS administration. I have installed SAS 9.3 in a Unix environment and also established connectivity with SQL Server. Now what I want to do is to customize SAS invocation command like below:-

SASt - Will connect to test server on SQL server

SASq - Will connect to QA server on SQL server

SASp - WIll connect to the SQL production server

Currently, I write ./sas to invoke SAS in my environment.

Any help in this matter will be greatly appreciated.

Let me know if additional information is needed.

Thanks in advance...

Re: Customize SAS invocation command

AnandVyas — Tue, 14 Jan 2020 03:20:26 GMT

Hi @ashrivastava

Instead of changing the default sas invocation, I would advise you to write a wrapper script and then let the wrapper invoke SAS with required customization.

Re: Customize SAS invocation command

Kurt_Bremser — Tue, 14 Jan 2020 06:27:22 GMT

Set up separate application servers for the three contexts. Define the different library connections for the relevant servers.

Re: Customize SAS invocation command

ashrivastava — Tue, 14 Jan 2020 17:01:15 GMT

Thanks for the suggestion. Could you please explain a bit more about this wrapper script?

Re: Customize SAS invocation command

alexal — Tue, 14 Jan 2020 18:22:10 GMT

@ashrivastava ,

Here is a simple wrapper script to invoke Base SAS:

#!/bin/sh -p

SASROOT=/path/to/SASFoundation/9.4
SAS_COMMAND=$SASROOT/sas

Quoteme() {
   if [ $# -gt 1 ]; then
      quoteme="\"$*\""
   else
      quoteme=$1
   fi
}

cmd="$SAS_COMMAND"

for arg in "$@" ; do
   Quoteme $arg
   tmp="$quoteme"
   cmd="$cmd $tmp"
done

eval exec $cmd

Re: Customize SAS invocation command

AnandVyas — Wed, 15 Jan 2020 03:27:01 GMT

Do you use a single odbc.ini to setup all 3 sqlsrvr data sources or separate files?

Re: Customize SAS invocation command

AnandVyas — Wed, 15 Jan 2020 03:29:06 GMT

In this scenario, he will have to use sasbatch.sh for the configurations to load for separate app contexts. If sas binary is directly launched from foundation directory, those configurations won't be read during session launch.

Re: Customize SAS invocation command

ashrivastava — Wed, 15 Jan 2020 17:03:37 GMT

Hi Anand, Thanks for the reply.

I have to use a single odbc.ini file to connect to multiple SQL servers (test, prod, and uat) and databases. We have this kind of setup in our old server but now we moved to a new server (the person who set up the old server is no longer here), where I installed SAS but unable to replicate the way we used to invoke SAS i.e. SASp for production, SASq for test etc.

Here is a sample of an old SASd script: -

#!/usr/bin/ksh
. /home/sas9/sub.profile
cd /home/sasapps/uat/programs

#initialize batch parameter constants
BATCHPARMS="-work /home/tmp -nonews -rsasuser"

nice /home/sas9/sas $BATCHPARMS -autoexec "/home/sasapps/uat/programs/autoexec.sas" &

sub.profile: -

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.:\
/sybase11/bin:/home/sas9:/home/userid/utility
SYBASE=/sybase11
LIBPATH=/path/to/odbc/lib/file
LANG=en_US
ODBCHOME=/path/to/odbc
ODBCINI=/path/to/odbcini
export PATH SYBASE LIBPATH LANG ODBCHOME ODBCINI

autoexec.sas

filename senv '/path/to/sas/programs';

%global senvcode;
%global senvpath;
%let senvcode = %scan(%sysfunc(pathname(SENV,f)),-2,'/');
%let senvpath = %sysfunc(pathname(SENV,f));

options nonotes;
filename whoami pipe 'whoami';
data _null_;
infile whoami;
input;
if _infile_ eq 'poldenka' then call execute('%options_statement');
run;
options notes;

libname sasdata '/path/to/library/data';
libname saswrite '/path/to/library';

options sasautos=("%sysfunc(pathname(SENV,f))/sasmacro"
"/home2/sasapps/uat/programs/sasmacro"
'!SASROOT/sasautos'
);

Then from command line (old server) when I type commands like SASd, SASp, SASq, it invokes respective SAS and automatically connects to respective server.

Thanks in advance!!

Re: Customize SAS invocation command

ashrivastava — Wed, 15 Jan 2020 17:04:47 GMT

We don't want to set up multiple servers.

Re: Customize SAS invocation command

AnandVyas — Fri, 17 Jan 2020 08:20:09 GMT

Thanks for sharing the old script. What does LIBPATH is pointing to in sub.profile file? I think it's the libname statement?

Re: Customize SAS invocation command

Tom — Fri, 17 Jan 2020 15:02:16 GMT

@ashrivastava wrote:

Hi,

I am relatively new to SAS administration. I have installed SAS 9.3 in a Unix environment and also established connectivity with SQL Server. Now what I want to do is to customize SAS invocation command like below:-

SASt - Will connect to test server on SQL server

SASq - Will connect to QA server on SQL server

SASp - WIll connect to the SQL production server

Currently, I write ./sas to invoke SAS in my environment.

Any help in this matter will be greatly appreciated.

Let me know if additional information is needed.

Thanks in advance...

What exactly needs to change to connect to a different server? Do you need to run different SAS code? Set different environment variables? Set different SAS options? Set different SQL server options?

It might be that all you need is three dummy scripts that just do something and then call the existing script.

You might even be able to just make an alias if all you need to change is to add some command line switches.

Re: Customize SAS invocation command

ashrivastava — Fri, 17 Jan 2020 17:07:53 GMT

I think I figured it out. I changed the path in old script to point to my current and respective path and it seems to be working now as when I use SASd command it opens SAS.

Thanks all for responses.