How to get SAS datasets from Sas Server from jupyter lab

[SeunghoKang]

Hello!

Resently i made a connection between SAS work server and jupyter lab(on my pc) by Saspy.

and i wanted to get datasets from SAS server to analysis something.

so i have tried  >> df = sas.sasdata("table", "library name") on jupyter lab and excuted df.describe(),

but it was not i wanted. because i just showed table's summary and speed was extreamly slow! 

what i want to know is this : 

1. Ways to impove speed of data loading from Sas server.

2. How can i see Full dataset from jupyter lab and store it in my pc.

3. Are there's some way to Download datasets in Sas Server to My pc with Saspy(or other package)?

please let me know. Thank you 🙂

[AnandVyas]

Hi @SeunghoKang 

Slow performance could be due to slow network speed for the data transfer between client and server. If your data is huge and the connectivity is shared or via VPN you can experience extreme slowness. To improve it see if you can connect to a better network or get your client connection as close as possible to the data storage and server.

Since the SAS execution is happening on the remote server and what you see on the client is just the output, all the SAS libraries or data that you save will be on server storage. If you have any shared storage or network drive on server which can be shared on client, you should be able to access data seamlessly. 

There are other options as well that you can use to download data like using sFTP, Download procedure which requires SAS/Connect, or using download option from SAS Studio.

[SeunghoKang]

First of all, thank you for your answer.
But i want to know data download methods based on jupyter lab.(not sFTP or etc...)
please let me know

[AnandVyas]

Hi @SeunghoKang 

I understand. But SASPy is just an interface to SAS and since you are running your SAS Session on a remote server creating or downloading datasets would require an additional step. If your SASPy was running on a local machine along with your SAS, then you could have used SAS libraries to create a permanent dataset on your local machine itself.

[SeunghoKang]

thank you again.
how about this case, if i was tired same work in different environment?
i mean, if i was trying to connect to SAS server from jupyter hub?(because i am planning to install physical python server with jupyter hub and it will be connected with SAS server).
Any ways to get datas with jupyter hub? or not? or still other ways are the best, like sFTP or etc.. as you suggested?
i need your advice.