Accessing tables from 2 sas servers

[toesockshoe]

So I have 2 servers: server 1 and server 2 (both in SAS).

I have table 1in server 1 that I need to left join with table 2 in server 2. I am unsure how to d othis.

Right now I have a program that has server 1 as a selected server. I can access table 1 of course, but I have no idea how to access table 2 in server 2. Any ideas? This is in sas enterprise guide.

I tried " libname lib2 path server = server2; but I get an "Invaluid value for the SERVER option" error. as well as Libref server2 is not assigned and error in the libname statement errors.

[Kurt_Bremser]

Tell us more about your setup. Are those servers on different hosts? Where are the libraries located (local disks, SAN, network shares)?

Do you have SAS/CONNECT licensed?

[toesockshoe]

is there an easy way to find that out on SAS? I'm doing this as part of work and my manager and coworkers and unfamiliar with SAS

[Kurt_Bremser]

Right-click on the servers in the serverlist, select Properties.

And someone has to have that information anyway, because SAS does not install itself out of the blue.

[toesockshoe]

It's not local drive for sure... it's a share network most likely because everyone in the company has access to these files... im not sure if I have SAS/CONNECT... how do I check?

[TomKari]

When you look at your server list with "View > Servers", do both servers appear under the "Servers"? If so, both servers are available in the same metadata server environment. If not, you'll need to switch between different metadata profiles.

Tom

[toesockshoe]

yup theyre both in the same metadata server environment... is there an easy way to refer to tables in both servers then?

[Kurt_Bremser]

Submit

proc setinit;
run;

to get a listing of your license in the log.

[toesockshoe]

ok I have sas/connect... how do I join the tables in different servers now? Thanks again!

[toesockshoe]

ok yes I have sas/connect licensed and installed

[SASKiwi]

What OSs do your SAS servers run on? If they are both Windows then a LIBNAME statement pointing to a file share (\\ServerName\FolderName) between the servers is easier than using SAS/CONNECT. You might need to get IT Admin to set these up for you though.