BookmarkSubscribeRSS Feed
Sk1_SAS
Obsidian | Level 7

Hello powerusers, 

 

We have our main server and the business users have another one. 

 

Our server: SASAppExample1

Business server: SASAppExample2

 

I can assign normally the libname CARS for example in SASAppExample1 server, the path is:

 

LIBNAME CARS '/department/sasdata/Lev1/ETL/ODS/CARS'; 

But when i'm connected to SASAppExample2 server and i'm trying to assign the libname CARS its not possible, this is the WARNING:

 

28         LIBNAME CARS  '/department/sasdata/Lev1/ETL/ODS/CARS'
NOTE: Libref CARS refers to the same physical library as CARS.
WARNING: Library CARS does not exist.
NOTE: Libref CARS was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: /departament/sasdata/Lev1/ETL/ODS/CARS

I've already assigned CARS library in server SASAppExample2 in SMC. 

 

The engine is V9.

 

Do you know what i need to do?

 

Thanks a lot.

 

 

 

4 REPLIES 4
SASKiwi
PROC Star

Most likely the path/folder /department/sasdata/Lev1/ETL/ODS/CARS is defined on server SASAppExample1 but not on SASAppExample2. You will need to talk to your SAS administrator about getting a folder share set up so that path is available on the second server. This is an OS configuration and nothing to do with SAS.    

Sk1_SAS
Obsidian | Level 7

There is no way to connect using "SERVER" in libname? we can connect to a lot of sources, oracle, db2 and etc

Kurt_Bremser
Super User

You will need something that acts as a server process.

If you have SAS/CONNECT licensed, you can establish a CONNECT session to the other server and use Remote Library Services to read data from there.

If not, you need to have a network share defined on the source server and mount it on the target where you run your SAS.

A third alternative would be SAS/SHARE, but that is rarely used (and therefore licensed) these days.

Sajid01
Meteorite | Level 14

As I see in your question the libname assignment refers to a folder i.e., a location on the filesystem.

I assuming that you are connected to the first server and want to access a location on the second server.

In such a scenario, the disk on the second server would need to be mounted on a folder  (if the first server is Linux machine ) or mapped to the first server as a drive (If the first server is a windows server).
The location on the second server will now appear as a folder on the first server. For a user this is effectively a location on the first server.
Typically for sharing between servers there are shared drives and disk on one server is not mounted on another.

This activity of mounting / mapping the disks is something which is done by the Operating System Administrators / Storage Administrators. Your SAS Administrator can co-ordinate the activity and should be able to assist.

 

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 2381 views
  • 2 likes
  • 4 in conversation