Connecting to RDC and fetting the Data

[Vipin]

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.

[Patrick]

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.

[SASKiwi]

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';

[LinusH]

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

[Vipin]

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

[Patrick]

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

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

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

[LinusH]

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.