topic Re: Connecting to RDC and fetting the Data in SAS Data Management

Connecting to RDC and fetting the Data

Vipin — Tue, 06 Oct 2015 06:02:32 GMT

Hi I am Vipn.

I am wondering if using SAS on my local desktop, I can define the library from RDC whose information I know is as follows (only an example):

IP Address for RDC - 100.10.100.100

Userid - DOMAIN\Vipin.XYZ

password - xxxxxx@xxx

Path of Library on RDC - C:\Desktop\Data\WORK

Where RDC I am referring to is Remote Desktop Connection.

Please suggest what should be done.

Re: Connecting to RDC and fetting the Data

Patrick — Tue, 06 Oct 2015 08:38:02 GMT

All SAS code gets executed on the SAS server side. You must address filesystems as they are "seen" by your SAS server and you can only access what's accessible from your SAS server. A local C-drive is normally not accessible unless you've shared it on the network and the SAS server has also access to this network.

Re: Connecting to RDC and fetting the Data

SASKiwi — Tue, 06 Oct 2015 23:13:19 GMT

If your network folks are agreeable, you could get them to set up a network share to the C drive of the RDC PC, for example called C$. Then you could assign a LIBNAME in SAS using a UNC path:

libname RDC '\\RDCPCName\C$\Desktop\Data\WORK';

Re: Connecting to RDC and fetting the Data

LinusH — Wed, 07 Oct 2015 00:16:12 GMT

@Vipin, I think I need more details to help you out.

Local SAS, do you refer to a SAS DMS (aka Foundation) client, or any of the thinner clients, such as Enterprise Guide?

Do you have any SAS server/service on your RDC host? Object/Connect spawner, SAS/SHARE etc...

If you wish to access this location directly from your local PC, have the server admin make a share (and make sure you have the necessary access rights).

Re: Connecting to RDC and fetting the Data

Vipin — Fri, 09 Oct 2015 16:51:32 GMT

@ LinusH:

So to explain it more, I am having my laptop where Windows SAS 32 bit is installed. And I have a server/RDC where I login using some IP address and password and then I can work on the server using the SAS present there. So, I wanted to know if I can use some commands in my laptop's sas to access the SAS dataset present on Server.

I am not sure if there exist some commad which I can use to specify the IP address and password to access Server and folders there.

Re: Connecting to RDC and fetting the Data

Patrick — Sat, 10 Oct 2015 00:02:46 GMT

@Vipin

What will work depends on your environment. Here some options. Depending on your Server and Laptop environment (eg. "bitness") you need eventually to first create a transport file for data exchange (proc cport/cimport).
http://support.sas.com/documentation/cdl/en/movefile/67439/HTML/default/viewer.htm#p0p45wa0uwhgcan1e6xwi9jy53j6.htm

A: From the SAS Server write the data set to a network drive which is also accessible from your laptop.

B: Download the SAS file using the filename FTP engine

https://support.sas.com/documentation/cdl/en/lestmtsref/68024/HTML/default/viewer.htm#p0v0ijxl1k6d4bn16cshtic7u4i3.htm

C: Use Remote Library Services. This requires SAS/Connect licensed and installed.

http://support.sas.com/documentation/cdl/en/connref/67933/HTML/default/viewer.htm#n1oda0s1uwd6nqn1ofyq60lgfp9z.htm

😧 Use SAS Enterprise Guide on your PC.

And writing down options for you I remembered that Chris Hemmedinger wrote about this in his blog...

http://blogs.sas.com/content/sasdummy/2013/05/20/export-and-download-any-file-from-sas-enterprise-guide/

http://blogs.sas.com/content/sasdummy/2012/12/06/copy-files-in-sas-eg/

Re: Connecting to RDC and fetting the Data

LinusH — Sat, 10 Oct 2015 08:22:58 GMT

In your situation, @Patrick option D is the most "modern" approach. Requires a metadata server and an object spawner.

If you gave SAS on both ends, SAS/CONNECT is an option. Using rsumbit; to do the processing on the server side.