SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Connecting to RDC and fetting the Data

Reply
New Contributor
Posts: 2

Connecting to RDC and fetting the Data

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.

 

Respected Advisor
Posts: 4,186

Re: Connecting to RDC and fetting the Data

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.

Super User
Posts: 3,307

Re: Connecting to RDC and fetting the Data

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';
Super User
Posts: 5,491

Re: Connecting to RDC and fetting the Data

@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).

Data never sleeps
New Contributor
Posts: 2

Re: Connecting to RDC and fetting the Data

@ 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.

Respected Advisor
Posts: 4,186

Re: Connecting to RDC and fetting the Data

[ Edited ]

@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#p0p45wa0uwhgcan1e...

 

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#p0v0ijxl1k6d4b...

 

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#n1oda0s1uwd6nqn1of...

 

D: Use SAS Enterprise Guide on your PC.

Capture.PNG

 

 

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-gu...

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

 

 

 

Super User
Posts: 5,491

Re: Connecting to RDC and fetting the Data

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.
Data never sleeps
Ask a Question
Discussion stats
  • 6 replies
  • 353 views
  • 0 likes
  • 4 in conversation