topic Re: Cannot see the tables in a SQL libname from Viya server - SAS EG in Administration and Deployment

Cannot see the tables in a SQL libname from Viya server - SAS EG

SasStatistics — Thu, 13 Jan 2022 12:50:50 GMT

My organization has recently chaged/updated to Viya meaning that we have done a switch from Windows to Linux.

For some libnames (it seems like it is SQL databases - all libnames I have encountered the problem on so far is on SQL databases) I cannot see the tables in the libname from SAS Enterprise Guide, although I can use them as normal, for example by a data step or proc print.

So to make it more clear, this is basically how it looks on the Viya server (I only see the libname but cannot see the corresponding tables):

And this is how it looks like on the older version, Windows server (I can see the libname and the corresponding tables):

It is quite annoying, any ideas on what the problem could be or how to solve it?

Re: Cannot see the tables in a SQL libname from Viya server - SAS EG

JosvanderVelden — Thu, 13 Jan 2022 13:43:33 GMT

Which interface are you using?
A coding environment like SAS Studio 3.8 or SAS Studio V or another visual interface?

Best regards, Jos

Re: Cannot see the tables in a SQL libname from Viya server - SAS EG

gwootton — Thu, 13 Jan 2022 14:46:11 GMT

If you right-click the library in Enterprise Guide and choose "refresh" does it list the tables? Does PROC DATASETS list all the tables for the library?

Re: Cannot see the tables in a SQL libname from Viya server - SAS EG

SasStatistics — Thu, 13 Jan 2022 16:26:26 GMT

SAS Enterprise Guide (EG).

Re: Cannot see the tables in a SQL libname from Viya server - SAS EG

SasStatistics — Thu, 13 Jan 2022 16:30:00 GMT

Refresh does not help.

For proc datasets lib = MyLib i get the error:
WARNING: No matching members in directory. Weird since I can use the tables in a proc print step say?

Re: Cannot see the tables in a SQL libname from Viya server - SAS EG

ballardw — Thu, 13 Jan 2022 17:22:33 GMT

@SasStatistics wrote:
Refresh does not help.

For proc datasets lib = MyLib i get the error:
WARNING: No matching members in directory. Weird since I can use the tables in a proc print step say?

You might share the entire log for that Proc datasets. Include all the Proc code and all notes from the procedure. Copy from the log and paste the entire bit into a text box opened on the forum with the </> icon.

Re: Cannot see the tables in a SQL libname from Viya server - SAS EG

SASKiwi — Thu, 13 Jan 2022 21:09:24 GMT

Is it only database libraries that are affected? You shown the example of SASHELP that is a SAS library - does that work OK on Viya. Also what is your Viya version?

Re: Cannot see the tables in a SQL libname from Viya server - SAS EG

SasStatistics — Fri, 14 Jan 2022 12:30:31 GMT

running

proc setining;

yields: Current version: V.03.05M0P111119

Showing SAS library works fine, other libraries works fine aswell - but those that I cannot see the tables from are SQL servers.

Re: Cannot see the tables in a SQL libname from Viya server - SAS EG

gwootton — Fri, 14 Jan 2022 14:18:31 GMT

Are there any SQL libraries that do not have this issue? Is the situation described in the SAS Note below a possibility?

Problem Note 16740: "WARNING: No matching members in directory" using LIBNAME statement for SAS/ACCESS Interface to OLE DB to access SQL Server with PROC DATASETS
https://support.sas.com/kb/16/740.html