BookmarkSubscribeRSS Feed
apolodor
Calcite | Level 5

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!

23 REPLIES 23
Peter_C
Rhodochrosite | Level 12

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

apolodor
Calcite | Level 5

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

Peter_C
Rhodochrosite | Level 12

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.

apolodor
Calcite | Level 5

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?

Haikuo
Onyx | Level 15

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

apolodor
Calcite | Level 5

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.

Haikuo
Onyx | Level 15

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

apolodor
Calcite | Level 5

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!

Haikuo
Onyx | Level 15

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.

apolodor
Calcite | Level 5

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?

Haikuo
Onyx | Level 15

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?

apolodor
Calcite | Level 5

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

Haikuo
Onyx | Level 15

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

FriedEgg
SAS Employee

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 23 replies
  • 2000 views
  • 0 likes
  • 6 in conversation