topic Re: How to create/define SAS/CONNECT Signon script? in SAS Programming

How to create/define SAS/CONNECT Signon script?

apolodor — Tue, 24 Sep 2013 07:05:30 GMT

How can I create/define SAS/CONNECT Signon script to connect to SAS 9.2?

I was told that first I have to install SAS/CONNECT and SAS/BASE utilities on the local workstation (Windows).

Thank you!

Re: How to create/define SAS/CONNECT Signon script?

Peter_C — Tue, 24 Sep 2013 07:24:14 GMT

when SAS is licensed with /Connect the install creates sample scripts on your system

Re: How to create/define SAS/CONNECT Signon script?

apolodor — Tue, 24 Sep 2013 07:38:33 GMT

Could you please tell me where can I find it and how can I test it?

Re: How to create/define SAS/CONNECT Signon script?

Peter_C — Tue, 24 Sep 2013 12:54:05 GMT

In a standard sas session run

%PUT %SYSGET(SASSCRIPT);

The log should show the path where the example SAS/Connect scripts are stored

Each script is designed for a particular server type and connection type. These are desxribed in the fileheaders.

Re: How to create/define SAS/CONNECT Signon script?

apolodor — Tue, 24 Sep 2013 13:28:01 GMT

Thanks!

Is there a sample script file I could re-use?

Where can I find SAS/Connect scripts? Do I need to install SAS/CONNECT software? Does it come as a separate package?

Re: How to create/define SAS/CONNECT Signon script?

Haikuo — Tue, 24 Sep 2013 13:42:43 GMT

In my default CFG file, SASSCRIPT was set as a SAS option instead of environment variable. In that case, you can use:

%put %sysfunc(getoption(SASSCRIPT));

You do need to install SAS/Connect. No, it is usually included in your deployment depot, you just need to check it to have it included.

Haikuo

Re: How to create/define SAS/CONNECT Signon script?

apolodor — Tue, 24 Sep 2013 13:56:56 GMT

Thanks Haikuo!

Well, I don't know how I could check that option.

I just installed SAS Drivers for JDBC and SAS/CONNECT for Windows so now I have some jar files under C:\Program Files\SAS\SASDriversforJDBCandCONNECT\9.1 but no script files.

Re: How to create/define SAS/CONNECT Signon script?

Haikuo — Tue, 24 Sep 2013 14:59:22 GMT

To check the licensing info:

PROC SETINIT;RUN;

To check the installed components :

PROC PRODUCT_STATUS;RUN;

You will need SAS/CONNECT both licensed and installed.

HTH,

Haikuo

Re: How to create/define SAS/CONNECT Signon script?

apolodor — Wed, 25 Sep 2013 12:40:53 GMT

It looks that SAS/CONNECT is both licensed and installed.

PROC SETINIT;RUN;

Product expiration dates:

---Base Product ...

---SAS/CONNECT ...

---SAS OLAP Server ...

...

PROC PRODUCT_STATUS;RUN;

For SAS/CONNECT ...

Custom version information: 9.21_M2

Where should I find the (sample) scripts?

Thanks!

Re: How to create/define SAS/CONNECT Signon script?

Haikuo — Wed, 25 Sep 2013 12:44:07 GMT

Have you run the statement suggested by Peter or me?

I have asked you to run:

%put %sysfunc(getoption(SASSCRIPT));

This will hopefully give you the location of the sample script.

Re: How to create/define SAS/CONNECT Signon script?

apolodor — Wed, 25 Sep 2013 13:21:09 GMT

I ran the ones mentioned by you

Now I executed the last command and I got:

.....

15	%put %sysfunc(getoption(SASSCRIPT));

(!SASROOT/misc/connect)

.....

However, there is no /misc/connect folder under C:\Program Files\SAS on my workstation. Should I look on the server?

Re: How to create/define SAS/CONNECT Signon script?

Haikuo — Wed, 25 Sep 2013 13:47:31 GMT

Ok, so you have nested variable here, run the following to figure out what is SASROOT:

%put %sysget(SASROOT);

Please provide more details on your SAS version, OS etc on both of your PC and your SAS server.

UPDATE: Also, did you run it straight, or did you run it using rsumbit?

Re: How to create/define SAS/CONNECT Signon script?

apolodor — Wed, 25 Sep 2013 13:55:07 GMT

Running %put %sysget(SASROOT) I got:

....

15	%put %sysget(SASROOT);

/sas/sas92/SASFoundation/9.2

....

There is no such folder on my workstation so I'd guess I have to look on the server.

Those commands were executed using SAS Enterprise Guide -> Program.

SAS version: 9.2

Server OS: AIX

Workstation OS: XP

Re: How to create/define SAS/CONNECT Signon script?

Haikuo — Wed, 25 Sep 2013 14:09:28 GMT

Your conclusion makes sense.

If you are using EG, make sure which machine you are running on. It could be local, which in your case, it is Windows XP, if remote, depends on how many different platforms involve, for now, at least you have one server that is AIX.

BTW, out curiosity, since you already running EG, why bother resort to SAS/Connect script? EG is taking care of everything in the background without your knowing, so is there anything that 'Rsubmit' can do, while EG can't?

Haikuo

Re: How to create/define SAS/CONNECT Signon script?

FriedEgg — Wed, 25 Sep 2013 15:51:37 GMT

There are still times in EG when using rsubmit makes sense as part of processes that take advantage of the MPCONNECT methods in SAS/CONNECT. There are other reasons as well but I refrain from listing them here.

Re: How to create/define SAS/CONNECT Signon script?

Haikuo — Wed, 25 Sep 2013 16:08:42 GMT

FG,

I 'd appreciate you would send me a private message on those other reasons. haikuo.bian@gmail.com

Thanks,

Haikuo

Re: How to create/define SAS/CONNECT Signon script?

apolodor — Thu, 26 Sep 2013 06:44:16 GMT

Well, I need those SAS/CONNECT Signon scripts beside SAS interpreter (to run SAS commands).

I am trying to access SAS data (read/write) using Oracle Data Integrator tool; see page 96 from http://www.oracle.com/technetwork/testcontent/oracledi-km-reference-130306.pdf

I am pretty new to the "SAS World" so maybe you can share some hints related to this topic.

Thanks again!

Re: How to create/define SAS/CONNECT Signon script?

Peter_C — Thu, 26 Sep 2013 06:56:30 GMT

I think you need to speak to your sas site support representative or SAS technical support - contact details at http://support.sas.com

Re: How to create/define SAS/CONNECT Signon script?

apolodor — Thu, 26 Sep 2013 07:39:05 GMT

It should be straight forward ... Why is it complicated to locate those scripts?

Re: How to create/define SAS/CONNECT Signon script?

Peter_C — Thu, 26 Sep 2013 19:45:41 GMT

Probably the only reason for complexity is because your sas client is installed "incomplete".

A complete install of SAS including SAS/Connect would have built and filled the folder revealed by the SASSCRIPT option.

I expect the scripts would be available for a licensed user from sas customer support.

But remember, nearly always the script has to be adapted to suit your server.