topic Re: Accessing tables from 2 sas servers in SAS Enterprise Guide

Accessing tables from 2 sas servers

toesockshoe — Tue, 06 Aug 2019 16:54:09 GMT

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.

Re: Accessing tables from 2 sas servers

Kurt_Bremser — Tue, 06 Aug 2019 17:36:11 GMT

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?

Re: Accessing tables from 2 sas servers

toesockshoe — Tue, 06 Aug 2019 17:54:09 GMT

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

Re: Accessing tables from 2 sas servers

toesockshoe — Tue, 06 Aug 2019 18:01:56 GMT

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?

Re: Accessing tables from 2 sas servers

TomKari — Tue, 06 Aug 2019 18:15:33 GMT

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

Re: Accessing tables from 2 sas servers

toesockshoe — Tue, 06 Aug 2019 18:18:04 GMT

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

Re: Accessing tables from 2 sas servers

Kurt_Bremser — Tue, 06 Aug 2019 18:49:43 GMT

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.

Re: Accessing tables from 2 sas servers

Kurt_Bremser — Tue, 06 Aug 2019 18:55:13 GMT

Submit

proc setinit;
run;

to get a listing of your license in the log.

Re: Accessing tables from 2 sas servers

toesockshoe — Tue, 06 Aug 2019 19:54:35 GMT

ok yes I have sas/connect licensed and installed

Re: Accessing tables from 2 sas servers

toesockshoe — Tue, 06 Aug 2019 19:55:10 GMT

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

Re: Accessing tables from 2 sas servers

SASKiwi — Tue, 06 Aug 2019 21:27:02 GMT

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.