SAS server connection using Python

[SeunghoKang]

Hello,

At the moment, on my local pc, SAS Enterprise Guide 8.2 has installed and there are many 

data files on the SAS server(windows based)) 

And i'm trying to use python(anaconda jupyter lab on local pc).

so i need to connect to SAS server to get data files on SAS server.

i have tried some methods and i found SASpy, so i have installed Saspy and sas kernel packages.

but i don't know how to make a connection between sas server and jupyter lab with these packages

please tell me how to solve it! 

🙂

[AnandVyas · Accepted solution]

Hi @SeunghoKang 

I hope when you say you want to get data files on SAS Server you mean to access them and not copy.

Since you are connecting to SAS installed on remote windows server there are two options available:

IOM using Java
The integrated object method (IOM) connection method supports SAS on any platform. 
This method can make a local Windows connection and it is also the way to connect to SAS Grid through SAS Grid Manager. 
This method can connect to a SAS Workspace Server on any supported SAS platform.

IOM using COM
This connection method is for Windows clients connecting to a remote SAS 9.4 host. 
This method takes advantage of the IOM access method, but does not require a Java dependency. 
SAS Enterprise Guide or SAS Integration Technologies Client (a free download from SAS Support) is required to install the SAS COM library on your client system.

Since you already have SAS Enterprise guide and saspy installed on your machine, you need few details to make the connection using https://sassoftware.github.io/saspy/install.html#iom-using-com

If you have access to remote SAS machine using EG run the below command to get the GUID. This is an identifier that you will need to make a connection.

proc iomoperate;
    list types;
run;

Example output:

SAS Workspace Server
    Short type name  : Workspace
    Class identifier : 440196d4-90f0-11d0-9f41-00a024bb830c  /* this is a constant that doesn't change */

If you don't have access then you can request your SAS admin to get this information for you. You will also need the remote SAS machine hostname.

Follow the steps in the KB link below for a sample on the connect statement. https://support.sas.com/kb/64/755.html

[SeunghoKang]

i made it!
Thank you for your help.
🙂

[AnandVyas]

Happy to help! 🙂