BookmarkSubscribeRSS Feed
Vipin
Calcite | Level 5

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.

 

6 REPLIES 6
Patrick
Opal | Level 21

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
PROC Star

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
Tourmaline | Level 20

@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
Vipin
Calcite | Level 5
@ 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
Opal | Level 21

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

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/

 

 

 

LinusH
Tourmaline | Level 20
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1242 views
  • 0 likes
  • 4 in conversation